AD 94-05-05 R1
Registered aircraft · 26,231
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.
N3137HBeaty Larry · Newport Beach, CAN3137NLuana John L · Deford, MIN3138XBoardman Thomas M · Greenwich, NYN3139HRegistered aircraftN313BCVan Meter Benjamin · Tumwater, WAN3140ASzablowski Walter · Riegelsville, PAN3140HLayne John A · Danville, INN3140JSmith Franklin R Sr · York, SCN3140XGerasimov Gennady · Jefferson City, MON3141AHoppe Joel A · Mankato, MNN3141BGoettemoeller Matthew W · Oldtown, IDN3141HSheddan Henry W · Live Oak, FLN3141NSale Reported · Lone Jack, MOSale reportedN3141VRenner Thomas J · Williston, NDN3141XMalo Lee M · Peabody, MAN3142AKrueger Robert C · Glenburn, MEN3142NMcdonald Collin D · Carthage, TNN3143ASkyline Holdings LLC · Big Lake, AKN3143HBuckley Barney P · Colfax, WAN3143VWebb Hunter · Altonah, UTN3144JChaffey Union Junior College District · Alta Loma, CAN3147HRegistration Pending · Grand Forks, NDRegistration pendingN3147XSuperior Golf Course Maintenance LLC · Plantation, FLN3148JWoerle Edward R · Rossville, TNN3148NGoerger Allan E · Barney, NDN3148VConnor Gavin · Owensboro, KYN3148XJennings Dewey S · Springfield, MON3149AOlson Karl D · Fairbanks, AKN3149HGregory Vernon L · Swansea, SCN314AGAntique And Classic Aircraft International Inc · Sound Beach, NYN314BWCooper Matthew A · Seattle, WAN314DMMarshall Donald R · Cape Girardeau, MON314JMJ B Flying Club Inc · Weymouth, MAN314SKPerkins Robert · Laguna Vista, TXN3150JKeown Kyle W · Saint Charles, MON3150NPutnam Michael C · Topeka, KSN3150PPeterson Craig A · Sweeny, TXN3151ADavis William G · Mercer, MEN3151NWayman Richard · Crystal, MNN3153ALea Robert W · Minter City, MSN3154BRegistration Pending · Turner, MTRegistration pending, pending cancellationN3155VHutchinson Kevin J · Poplar Grove, ILN3156ANorth American Aero LLC · Madison, NEN3156HFoster Scott R · Federal Way, WAN3156VSchwartz Amy A · Chandler, AZN3157AToyon Properties LLC Series N3157a · Waco, TXN3157NRich Melody L Trustee · Port Hueneme, CAN3158BFischer Gregory · Willow, AKN3158HReed Brenda L · Hopland, CAN3158NAlbrecht Romaine C · Ohio, IL
Back to AD 94-05-05 R1