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.
N37841Otto Bryant C · Conway, ARN3784JMilbourn Edward M · Greenfield, INN3784RHaver Andrew A · West Bend, WIN3785FFloyd Mark E · Adairsville, GAN3785KBartholomew Don · Gardnerville, NVN3785LReeves Laina M · Sammamish, WAN3785ZHenry L Bodmer Inc · Kenmare, NDN3786EHughes J Lonny · Lake Crystal, MNN3786LClercqzubli Daniel De J · Antioch, TNN3786RPutnam Richard E · Redmond, WAN3787KStearns Edwin Ben Jr · Chandler, AZN3787RLummus Brett D · Forney, TXN3787TPrewett Jared · Houston, AKN3788FJohnson David M · Macon, GAN3788KSwift Museum Foundation Inc · Athens, TNN3788LStrano Ralphael · Linden, NJN3788RMayer Robert J · San Diego, CAN3788SMampel Gregory · New Port Richey, FLN3788VGraves Kenneth D · La Crosse, WIN3788WWiebe James R · Valley Center, KSN3789FJohnson Rachel H · Terrytown, LAN3789KLee Robert E · Medford, WIN3789RRegistration Pending · Eagle River, AKRegistration pending, pending cancellationN3789SSchilz Michael T · Townsend, WIFirst renewal noticeN3789ZBockstiegel Bill · Leadville, CON378AAUnderwood Bruce D · Woodruff, WIN378LARials Tommy G · Crystal Springs, MSN378VUDennis Ryan B · Delphi, INN3790LStandiford Keith P · Carmel, CAN3790RSjostedt Brad D · Cordova, AKN3790ZWilbright Debra A · Le Sueur, MNN3791LPowell County Flying Club Inc · Owingsville, KYN3791VTapia Samuel R · Barstow, CAN3792FSeals Floyd · San Marcos, CAN3792LBreinlinger Eric · Charlton, MAN3792SOld Blue Aviation Inc · Mayodan, NCN3792VBrown David L · Boyertown, PAN37937Schenck Norman W · South Bound Brook, NJN3793JMccoy Michael B · Colbert, WAN3793KVolpe Francis B · Boynton Beach, FLN3793LWarner Gary Dean Trustee · Cotter, ARN3793SWilt Richard A · Piseco, NYN3793VCrisp III Harold N · Universal City, TXN3794FN3794f LLC · Key West, FLN3794HWorley William M · Camden, NCN3794LSearcy Moto-Air Inc · Searcy, ARN3794RHollis John A · Payette, IDN3794TFournier Mark R · Carabaset Vly, MEN3794VGuynn James H · Arlington, VAN37959Collins Dennis L · Richland, WA
Back to AD 94-05-05 R1