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.
N89952Striegel William H II · Spangle, WAN89954Aviation Consulting Management Enterprises LLC · Bryant, ARN89958Frets Jason G · Gainesville, GAN89959King Mark R · Oxnard, CAN8995BSommerfeld David A · Assaria, KSN8995UKelley Aircraft LLC · Weyers Cave, VAN89965King Aubrey R · Salinas, CAN89968Warwick Dakota R · Jupiter, FLN8996BGartrell Kirk W · Amarillo, TXN89973Seward Leasing Inc · Guthrie, OKN89974Mulvania Rodney A · Linn, MON89977Hampton Stephen L · Culbertson, MTN89978Wilson Keith · Los Lunas, NMN8997SRed Barn Ag & Home Inc · Westville, OKN89982Kiper Kaleb · Fairbanks, AKN89988Carpentier Michael · Moses Lake, WAN8998BValles Rick James · Albuquerque, NMN89990Arbie Melvin J · Lake City, FLN89993Mossman Andrew Douglas · Pickerington, OHN89996Stauffer Bradley E · Milford, NEN89999Moreus Steven P · Sunfish Lake, MNN8999BRacoon Aviation LLC · San Antonio, TXN8999SLewis Darrell K · Morehead, KYN89EZWinward John · Long Beach, CAN89HPMorgan Howard P Jr · Longmont, CON89RSRutan Aircraft Flying Experience · Brookshire, TXN89RZZimmerman Gregory J · Iowa City, IAN89WWAley Jeffrey S II · Granby, CON89XBScofield Bruce W · Batavia, NYN8BAHoffman Schuyler · Brighton, CON8CXDinius Jeffrey H · Kaufman, TXN8CZRey Thomas A · Fort Worth, TXN8EDBlueskys Inc · Wilmington, DEN8EWSky West Aviation Inc Trustee · Albuquerque, NMN8JDClevenger Jim B · Kissimmee, FLN8JMOrion Ventures LLC · Kalispell, MTN8KKEaa Aviation Foundation Inc · Oshkosh, WIN8MRSolis Dan A · Fresno, CAN8NTDegerlund Elmer · Fairbanks, AKN8PWMiranda Alexander · Homestead, FLN90000White Steven M · Grapevine, TXN90004Forthofer Richard · King Salmon, AKN90007Emerson Byron D · Sisters, ORN9000BHanna Ryan D · Berthold, NDN9000UWhitaker Robbie L · Brooklet, GAN90025Hoffman David G · Givens Hot Springs, IDN90028Seiler Elliott R · Green Bay, WIN9002BWicklander Richard O · Spanaway, WAN9002RSmith Terry L · Atoka, TNN90034Hawkins Rayma J · Little Rock, AR
Back to AD 94-05-05 R1