AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N5566PTwig And Giggleberries LLC · Wichita Falls, TXN5566UKingsbury Janet L · Miramar, FLN5566WRegistered aircraftN5566ZAlex Lawrence P · Loves Park, ILN55671Brown Christopher A · Tigard, ORN55673Smith Gordon H · Racine, WIN55675Sykes Kinsley · Palm Coast, FLN55677Arrow II Aviation LLC · Rocky Mount, NCN55678Murdick Robert A II · Bluemont, VAN5567MAnderson Layne A · Wichita Falls, TXN5567PRegistered aircraftN5567QRicol Aviation LLC · Naples, FLN5567W3k Weavers Investment Group LLC · Shelbyville, KYN55680Madsen Pest Management LLC · Siren, WIN55687Rieber Russell C · Stockton, CAN5568PSimon Jack · Spring Hill, TNN5568QJ & F Aviation Adventure LLC · North Fort Myers, FLN5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationN55691Brown Alan · Lugoff, SCN55695Straight Arrow Aviation LLC · Aurora, ILN55696Walla Walla University · College Place, WAN55699Hill Caleb · Indianapolis, INN5569MWichita Flight Training LLC · Wichita, KSN5569PSpirit Wings Ltd · Wilmington, DEN5569QBrian C Elbert · Rochester, NHN5569UJapikse Bert · Pawleys Island, SCN5569WBridges Michael D · Clovis, NMN5569ZLevandowski Joseph · Hamburg, NYN556BKd Helicopters Inc · Shingleton, MIN556ERSunrise Aviation Inc · Ormond Beach, FLN556FLKarg Asset Management LLC · Pocahontas, ARN556GGooch Joel L · Sumter, SCN556JRSemmig Jeffrey C · Oceanside, CAN556KRWhitaker Robert M · Richfield, UTN556MKurdzel Mark A · Chattanooga, TNN556MKPickering Gordon D · La Pine, ORN556NDRainier Flight Service LLC · Renton, WAN556PAAviator Corp · Wilmington, DEN556PCChristiansen Aviation LLC · Wilmington, DEN556PSPotter Mark W · Portland, ORN556RAReece Construction Co Inc · Colt, ARN556RJHastings Rick Joe · San Antonio, TXN556RMMorrison Robert J · Rock Hill, SCN556RVKetter Ralph J · La Luz, NMN556RWEhrlich Randall V · Greenwich, CTN556SCSpartan Education LLC · Tulsa, OKN556SHNovember Alpha LLC · Dover, DEN556SPTexas State Technical College · Waco, TXN556WHRobert L Stephens · Argyle, TXN55700Curry Edwin A · Pearland, TX
Back to AD 81-18-04 R2