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.
N2936VMurphy Julian Ryan · Knoxville, TNN2937DCoffman Robert P · Bigfork, MTN2937JSchumann Jennifer Pauline · Conroe, TXN2937UHangar 47 Aviation LLC · Midvale, UTN2938NChesnut John W · Arlington, TXN29393Elrod Brent W · Cashion, OKN2939DHarold Robert E · Fairbanks, AKN2939HDecker John M · Camano Island, WAN2939US & S Aviation Co · Ball Ground, GAN293SABowe Joseph E DBA · Ocklawaha, FLN2940DRoesbery Charles J Jr · Cordova, AKN2940UShaw Monte L · Hillsboro, OHN2941JReilly Isabella · Prescott, AZN2941NBonn Fred H · Jamestown, KYN2942DBeasley William J Jr · Spring Hill, TNN2942JRegistered aircraftN2942SEvenson Don C · Moorhead, MNN2942UHughes Stephen Lee · Dothan, ALN2943HBreon Shawn · Rockford, ILN2943UHania Robert · Benicia, CAN2944DWeaver Brian J · Livingston, TXN2944JThomas Edward R · Piney Flats, TNN2944KHodges James M Jr · Manchester, GAN2944SChartrand Robert J · Brimley, MIN2944UMillsaps David C · Tuscumbia, ALN2945NMcdermott Max E · Alva, OKN2945UGriffith Ronald W Jr · Douglasville, GAN2945VMcclellan Stephanie · Hebron, ILN2946SFreed Michael · Sylmar, CAN2946UPearson Eugene L · Burns, KSN2947DMelin Clinton C Trustee · Big Lake, AKN2947JMaggio Anthony M · Harbor City, CAN2948JSale Reported · Ruston, LASale reportedN2949DJackson Carl · Martin, SDN2949NSchoettmer Thomas C · Greensburg, INN2949SRegistered aircraftN2950DKnight Todd · Grimes, IAN2950JRunway Aviation Flight Training USA Corp · Rockwall, TXN2950SJohnson Aviation LLC · Middleton, IDN2950UMorris Lawrence P Jr · Aberdeen, NCN2950VCollins Robert J · Kennett Square, PAN2951JJohnston Robert G · Rose Hill, KSN2951KJacobs John Henry · Fairfield, OHN2952UOrr Enterprises Inc · Hay Springs, NEN2953KAkin Mark P · Edgewood, KYN2953SKelley Mark · El Granada, CAN2954DRosales Mariano L III · Naperville, ILN2954UTiger Flight LLC · Lake Butler, FLN2955DWalsh David E · North Platte, NEN2955JAguilar Honorio Alejandro · Anna, TX
Back to AD 94-05-05 R1