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.
N698CACommander 1 Flight Group LLC · Wilmington, DEN698CHFranklin Ricky L · Glade Hill, VAN698CPSerodind Peterj · Chattanooga, TNN698FLNight Fox Aircraft LLC · Mesa, AZN698JABon Bon Aviation LLC · Daly City, CAN698MBravo Zulu International Ltd · Las Vegas, NVN698MADaher Michael P · Trabuco Canyon, CAN698NDUniversity Of North Dakota · Grand Forks, NDN698SHMccair LLC · Mineral Wells, TXN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN6990BE T Wells Inc · Helena, ARN6990DHorn Paul · Kodiak, AKN6990KReeves Donald L · Harrison Township, MIN6990WMadichar LLC · Lempster, NHN6990ZWabash Valley Soaring Association Inc · Lawrenceville, ILN6991HRhinelander Flying Service Inc · Palmetto, FLN6991KMoore Jeffrey D · Blossvale, NYN6991UHochstein Scott J · Skiatook, OKN6991WCarnes James Oscar Jr · Smiths Grove, KYN6992EMikkelsen John P · Sebastopol, CAN6992KGeser Ryan · Newberg, ORN6992RBanana River Aviation LLC · Merritt Island, FLN6992ZSoaring Club Of Houston Inc · Waller, TXN6993BFarneski Robert B · Fairbanks, AKN6993JCannon Maureen A · Wareham, MAFirst renewal noticeN6993KHudock Cody Jacob · Kill Devil Hills, NCN6993URamirez Arturo A · Lake Creek, TXN6994JLytle Tobin A · Grove, OKN6994KGarfield Joe · Morgan, UTN6994PHunt Ray A · Louisburg, NCN6994QGronewold Dale A · Gothenburg, NEN6994URegistered aircraftN6994VKroutil David W · Hilmar, CAN6994WCone Carl T · Statesboro, GAN6995BChase Kenneth W · Anvik, AKN6995CDetert Bradley · Valparaiso, INN6995DZimmerman Christian · Anchorage, AKN6995KShuey Kenny L · Neosho, MON6995PInternational Air Services Inc Trustee · Carson City, NVN6995RFeher Tara A · Chesapeake, VAN6995VHausmann Internaational Inc · Sugar Land, TXN6996AGrape Soda Adventures LLC · Weddington, NCN6996BAafedt Aaron B · Belgrade, MTN6996DByrd David P · King Salmon, AKN6996HWeirich Gayle M · Rockford, MIN6996PWelling Charles E III · West Islip, NYN6996UHanrahan William P · Seward, AKN6996WGiles David · Augusta, GAN6997DM & M Farms · Fowler, KSN6997JBailey Kevin R · Crown Point, IN
Back to AD 81-18-04 R2