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.
N973WDBaggenstoss William J · Weiser, IDN9741AHelzer Michelle A · Canby, ORN9741VGlenn Larry W · Bunn, NCN9742EForbes James A · Monkton, MDN9743AYokom James C · Wichita, KSN9743VBlevins Carl L · Mc Kenzie, TNN9744AKahrs Andrew J · Bainbridge Island, WAN9745TOwens Edward W · Raymore, MON9746APetey LLC · Bozeman, MTN9747TMapes James R · Ellensburg, WAN9748AJuhl Amanda · Centennial, CON97495Yankovich Michael C · Fredericksburg, VAN974SFAerospace Trust Management LLC Trustee · Wilmington, DEN9751APerla Guido F · Vashon, WAN9751TAbles Marlan L · Carthage, ARN9752ESmith Happy E · Rogersville, TNN9753AFowler Flyers Inc · Fowler, CON9753TCowan Ronnie C · Glasgow, KYN9759ALove John W Jr · Los Lunas, NMN975CCInternational Air Services Inc Trustee · Carson City, NVN9763ARoman Financial Inc · Monroe, WAN9768ABeachy Benjamin D · Whittington, ILN9769AGernetzke Jill R · Kingman, AZN976JLLatimer Jerry J Sr · Carrollton, GAN9770ANathan David L DBA · Fullerton, NEN9770DDestaffany Nelson D · Crawford, TXN9771MOwen Talbert · University Place, WAN9772AKerns Stanley M · Berryville, VAN9772MHeusinkveld Kevin D · Christiana, TNN9773AHoch Lance M · New Plymouth, IDFirst renewal noticeN9773MGregory Vernon L · Swansea, SCN9774AKuykendall Wayne · Waxahachie, TXN9775ATcb Flies LLC · Brooklyn, NYN9775MMetelmann Thomas K · Grand Forks, NDN9776AMoritz Randal L · Emily, MNN9777ABuxton Gretchen C · Spooner, WIN9778ACurrie Jason M · Kennard, TXN9779EStuckle Eugene A · Davenport, WAN9779THill Kevin D · Port Lavaca, TXN977DWJulien Kathleen Y · Gig Harbor, WAN977HBStrauel Isaiah J · Liberty, KYN9780TGilbert Tanner A · Midland, TXN9781ATate Amanda T · Fairbanks, AKN9781TPacheco James S · West Ossipee, NHN9782TFascenda Matthew Roman · Mint Hill, NCN9784DOrth Henry J · Wasilla, AKN9785QStory Allen D · Arlington, TXN9786THire Smart Folks LLC · Austell, GAN9787TMapes Peter B · Oscoda, MIN9788DGlynn Blake Trustee · Cedar Hill, TN
Back to AD 94-05-05 R1