AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N9333GEdinger Larry D · Stroudsburg, PAN9333TLiley Paul T · Anchorage, AKN9333X1927 Enterprises LLC · Overland Park, KSN93344Cardinal Headings Ltd · Wilmington, DEN9334AHusser Leonard A · Camano Island, WAN9334TNelson Scott M · Eagle River, AKN93350Rowe M D Trustee · Bozeman, MTN93354Utah County Sheriff · Spanish Fork, UTN9335CKoeritz Steven R · Anchorage, AKN9335EParanjpe Vasant · Pittstown, NJN9335XFlorida Gas Transmission Co · Spring, TXN93362Bouvier Ellis C · Prineville, ORN9336CLarson Lynn R · Casselton, NDN9337AStich Michael T · Malvern, OHN9337GHaller Lonette J · Mobile, ALN9337XValentine Richard E · Holt, FLN93380Stahla Robert E Trustee · Grand Island, NEN9338APeck Darren K · Noblesville, INN9338EComanche Hills Aircraft LLC · Lampasas, TXN9338XHathaway David P · Waterbury, VTN9338ZBarr Air Patrol LLC · Mesquite, TXN9339ASwede Aviation LLC · Tucson, AZN9339XSedona Aviation LLC · Sedona, AZN933CPCivil Air Patrol · Maxwell Afb, ALN933CSTextron Aviation Inc · Wichita, KSN933DDHarris John Alfred · Havana, FLN9340CWolfe Donald E · T Or C, NMN9341ARollison James · Scottsdale, AZN9341XKent Steven P · Warwick, NYN9342FChurchill David J · Bear, DEN9342GBaumann James J · Trabuco Canyon, CAN9343GOlivo Investments Group LLC · Richmond, TXN9343TJansen Guy A · Lynden, WAN9343XYoung Charles T · Los Banos, CAN9344CPage James S · Avoca, TXN9345CBunting Gordon E · Bend, ORN9345GFrederick Paul M · Tucson, AZN9345XBordner Christopher P · Santa Cruz, CAN9346AWilliams Darrell W · Fayetteville, ARN9347GNazir Donna Lacruz · Boca Raton, FLN9348AShelomis Dennis B · Shelton, CTN9348XWhittemore Kenneth P Jr · Fredericksburg, VAN9349MDouble R Air LLC · Miami, FLN9349XDicarlo Jason M · Covington, LAN934CPCivil Air Patrol · Maxwell Afb, ALN9350AGalloway Thomas E S · Oklahoma City, OKN9350CCloud Dancer Inc · Berlin, MDN9351FCarr Sam H · Spring, TXN9351XSasser Konnie B · Granbury, TXN9352CSage Blue LLC · Yakima, WA
Back to AD 84-10-01 R1