AD 2012-17-05
Registered aircraft · 1,197
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:2012-17-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-05')
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:2012-17-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-05') 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.
N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WAN312LGJet Masters LLC · Englewood, CON312STexas Aircraft Parts Brokers LLC · Seguin, TXN314CGN314cg Aviation LLC · Saint Louis, MON314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN314SJHrm Aviation LLC · Chesterfield, MON314TCTop Cat Aviation LLC · Pelham, ALN315RCRocklyn National LLC · Syracuse, NYN316CLCalco 316 LLC · Frisco, TXN316MFMf Property Management LLC · Hattiesburg, MSN316TDBas Part Sales LLC · Greeley, CON3170BSpring Mountain Enterprises Inc · Corvallis, ORN317CQPrivate Fliers LLC · Wheaton, ILN317TTInter Island Yachts Inc · Zephyr Cove, NVN318NWMed Jets USA Inc · Boca Raton, FLN31GJGlobal Jetcare Inc · Brooksville, FLN31KHAery Aviation LLC · Wilmington, DEN31LJDelta November LLC · Lewes, DEN31RARoyal Air Freight Inc · Waterford, MIN31YAInternational Trading Energy Fuels LLC · Houston, TXN31ZVEzair International Leasing And Management Inc · Wilmington, DEN31ZZE D Santos & Associates LLC Trustee · Wilmington, DEN320EJAlliance Aviation Group LLC · Wilmington, DEN320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedN321MSTaughannock Aviation Corp · Ithaca, NYN321VAValiair Limited Co Trustee · Casper, WYN322GC1mg LLC · Fort Wayne, INN322PRN322pr LLC · Scottsdale, AZN323AAE D Santos & Associates LLC Trustee · Wilmington, DEN325EXFalcon 325 LLC · Fort Pierce, FLN325JFN325jf Operating LLC · Dallas, TXN325NWKalitta Charters LLC · Ypsilanti, MIN325RDLow Tide LLC · Riverside, IAN327GALmi LLC · Alpharetta, GAN327MPSimsco LLC · Houston, TXN328JLLamon Aviation LLC · Boise, IDN328PCSn 328 Corp · Fort Lauderdale, FLN329TJForsythe Aviation LLC · Point Lookout, MON32HMAir Mellon LLC · Wilmington, DEN32KBS S K Hawker Group LLC · New Haven, CTN331JVBoulder Falcon LLC · Salt Lake City, UTN331SKD & E Aviation LLC · Missoula, MTN331USN331us LLC · Hillsboro, ORN333DLD&S Aircraft LLC · Chicago, ILN333KEFalconmitch Inc · Sulphur Springs, TXN333PCSemanik Investment Corp · Jacksonville, FLN335KBShelt William J · Denton, TXN335PRGy Aircraft LLC · Daytona Beach, FLN335RCN335 Aviation Corp · Middletown, DEN33612Pmdg Flight Operations LLC · Alexandria, VA
Back to AD 2012-17-05