AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N90154Mathis Ryan Blake · Madison, ALN90155Blanc Christopher F · Renton, WAN90163Roehm John P · Clinton, INN90164Boutwell Nathan G · Pelham, NHN90167Reeves Richard E · Lincoln, NEN9016BGray David W · Gnadenhutten, OHN90172Doll J M Smokey · Austin, TXN901742001 LLC · Lakeville, MNN90175Patz Michael · Anchorage, AKN90179Thomason Todd · Harrison, ARN9017BPancake C William Jr · Keyser, WVN90185Harris Frederick John Trustee · Port Townsend, WAN9018AGodbold Robert L · Apex, NCN90190Bobka Christian · NorthamptonshireN90192Johnson Dennis F · Detroit Lakes, MNN90195Meggers Roger D · Baker, MTN90199Stoddard David J · Lagrange, WYN901CECross John R · Canton, OHN901MSRozelle Kevin · Granbury, TXN901RJMiller James A · Granada Hills, CAN901SWWilson Paul C · Jefferson, GAN901UBowling Robert E · Argillite, KYN9022BMorris Nicholas R · Palmer, AKN9024AHarbick Joshua W · Bend, ORN9026AMoyer Michael · Duarte, CAN9027ABrowning Charles R · Fond Du Lac, WIN9029BWyatt Mary Ellen Personal Representative · Weirsdale, FLN902KSSmart Aviation Solutions Inc · Lakeland, FLN902MHaworth James M · Canby, ORN90302Mendoza Macario · Lancaster, CAN90305Varnado Jason P · Hattiesburg, MSN9030ALimbach Cynthia S · Verona, ILN90316Miller Charles · Bynum, TXN9031AKiesling Michael J · Omro, WIN9031BVan Winkle Randy M · Van Buren, MON90321Jackson Virgil Gene · Kingsport, TNN90323High Edward O · Winter Park, FLN90325Avent Barry G · Bennettsville, SCN9032AProag Services Inc · Mahnomen, MNN9032BThurmond Paul J · Huntley, MTN90333Gattuso Phillip Joseph · Healdsburg, CAN90334Watson Gary R · Modesto, CAN9033AEverson David · Redding, CAN90340Holliday Mark E · Lake Elmo, MNN90341Chileprop LLC · Mimbres, NMN9034QLambert Steven D · Henderson, KYN90352Wilson Stephen A · Granbury, TXN90355Williams Mike A · Hartsville, INN90356Rokosny Tyler · Port Orange, FLN9035BHewitt Robert J · Ringwood, NJ
Back to AD 94-05-05 R1