AD 2009-14-13
Registered aircraft · 1,377
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:2009-14-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-14-13')
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:2009-14-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-14-13') 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.
N248MSPilatus Aircraft USA Ltd · Broomfield, CON249GXWildcat Aviation LLC · South Salt Lake, UTN24XZ31dodge Air LLC · Kernersville, NCN250KKNeed For Speed Aerospace LLC · Downers Grove, ILN251JJTvpx Ars Inc Trustee · North Salt Lake, UTN251NGJa Investments Inc · Toledo, OHN253PCIntermountain Medical Transport LLC · Salt Lake City, UTN254DLCrimson Phoenix LLC · Kalispell, MTN256BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN256TWTw Leasing LLC · Oxford, CTN257TWTw Leasing LLC · Oxford, CTN257WBRoyal Gorge Management Consulting LLC · Canon City, CON259PCNew Mfis Holdings LLC · Topeka, KSN259TWTw Leasing LLC · Oxford, CTN25MTMiss Liberty LLC · West Hartford, CTN25NGWood River Aviation Partners LLC · Hailey, IDN25NXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN25UCHarns Pc-12 LLC · Perris, CAN25WAir Watkins LLC · Alpharetta, GAN25XMMccluer Aviation LLC · North Las Vegas, NVN260HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN261HBChamonix Air LLC · Boulder, CON261NXCitizens National Bank Of Texas · Waxahachie, TXN263RSNorthern Sky Leasing LLC · Middletown, DEN264SGAdventaire LLC · Minot, NDN264WFWilliams Tim DBA · Knoxville, TNN265NXCmr3 Holdings LLC · Newark, DEN266NGBlue Horizon Ventures LLC · Gadsden, ALN267PTBlades & Bars LLC · Montrose, CON267WFNeljo LLC · Charlottesville, VAN269CTAero27 Tn LLC · Cookeville, TNN269LGCoffin Simon P · RemseckN269NGRebel One LLC · Dover, DEN26KHConcord Jet Service Inc · Concord, CAN26NGAgb Warranty Services LLC · Warrenton, VAN26WRWonderful Orchards LLC · Shafter, CAN26XMAm Aviation LLC · Henderson, NVN270AFRigi Inc · Portsmouth, NHN2710BDrglfg LLC · Denver, CON271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2727KRegistered aircraftN272NGCactus Land Development LLC · Fountain Hills, AZN273SMGuardian Flight LLC · South Jordan, UTN276HDRussoms Cloud Server LLC · Montgomery, ALN277PCShc 2021 LLC · Grand Forks, NDN278JMJlm Aviation LLC · Winthrop, MEN278WCN278wc LLC · Greer, SCN27KNStuckey Connections LLC · Magnolia, TXN27NXValiair Lc Trustee · Casper, WYN281HSterling Air Service LLC · Corpus Christi, TX
Back to AD 2009-14-13