AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2694WDickerson Steven Micheal · Tipp City, OHN2696CUnited States Air Force · Peterson Afb, CON2696RBowen Diane M · Newbury, MAN2696TRsp Aero LLC · Griffin, GAN2696WButler Collin · Danvers, MAN2698WLivesay Wallace · Friendswood, TXN2698XHall Clinton Arthur Jr · Klamath Falls, ORN2699WKingman Connor Joseph · Lemoore, CAN269AReynolds Darryl G · Wills Point, TXN269ATSnyder Arthur P · Trevorton, PAN269BTorres Ramon A · Mulberry, FLFirst renewal noticeN269BFLehmann Micheal · Lena, ILN269BMOlsen Jared · Phoenix, AZN269CPCutler Adam Wilson · Kennebunk, MEN269DDAircraft Solutions Group LLC · Englewood, CON269EPEpic Aviation Inc · Denison, TXN269FGMustang Sally Aviation LLC · Camden, SCN269HAN269ha LLC · Manassas, VAN269HHCaprock Technical Services Inc · Kempner, TXN269JPBrones Jon P · Blanco, TXN269KGMvt Aviation LLC · Magnolia, TXN269KMParagon Airplane Leasing Co · Fort Myers, FLN269MDCactus Air Force LLC · Carson City, NVN269MGGeorgia Aviation Authority · Eastman, GAN269MPGustafson H Clayton · Woodbury, CTN269MRAgl LLC · Othello, WAN269PBHmw LLC · La Grange, NCN269RHUnterreiner Dean · Prince George, VAN269RTTodd Jon R · Georgetown, CAN269SFlightco Inc · Swainsboro, GAN269SFHarvey Kandace · Snohomish, WAN269STSalina Tree Inc · Salina, KSN269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationN269TJSenninger Thomas P · Clermont, FLN269TPPhoenix Leasing LLC · Menomonee Falls, WIN269TUAero Quest LLC · Olive Branch, MSN269VCRegistered aircraftN269WFThomas Wilmer C · Fairbanks, AKN269YADavenport Ross K · Raleigh, NCN269ZIziair LLC · Mclean, VAN26AAMustang Sally Aviation LLC · Camden, SCN26AESwallows Inc · San Jose, CAN26AUMaximum Entropy Inc · Wilmington, DEN26BMRegistered aircraftN26BQAb Prop Plane II LLC · Metairie, LAN26BYSnohoacro LLC · Mukilteo, WAN26CMLaurel Highlands Aeronautical Academy · Latrobe, PAN26CXCiholas Philippe A · Sedgwick, KSN26DCAce Aviation LLC · Reading, VTN26DHZurinsky Richard · Port Orchard, WA
Back to AD 2006-10-21