AD 2012-16-14
Registered aircraft · 779
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-16-14')
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-16-14')
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-16-14') 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-16-14') 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.
N426SASuperior Ambulance Aviation Inc · Elmhurst, ILN428CJNo Res LLC · Scottsdale, AZN428DRMaverick Air II LLC · Deer Park, WAN428JDDewberry Air LLC · Atlanta, GAN42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN42NFCest La Vie LLC · Piedmont, OKN42NHEagle Wings Capital LLC · Ponte Vedra Beach, FLN431JDBlue Pearl Aviation LLC · Saint Louis, MON4343FFrenkel Tardis Development Corp LLC · Dallas, TXN435DCGuardian Flight LLC · Lewisville, TXN435HHBank Of Utah Trustee · Salt Lake City, UTN438RVAero Jet Aviation I Inc · Fort Lauderdale, FLN43MFMed Flight Air Ambulance Inc · Albuquerque, NMN43TPAircraft Holding Solutions LLC Trustee · Newark, DEN440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN440JACreamer Pilot Services LLC · Fayetteville, ARN440WPBbft Aero Holdings LLC · Columbus, OHN441QCBank Of Utah Trustee · Salt Lake City, UTN442FPNord Aviation LLC · Lone Tree, CON445FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN445NAirblue Eagle Inc · Houston, TXN445TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN445WFScarmardo Cattle Company LLC · Caldwell, TXN449BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44LGHarborjet LLC · Petoskey, MIN44MBTria Entertainment LLC · Wisconsin Dells, WIN44VPGable S Corp · West Linn, ORN450FCN450fc LLC · Nashville, TNN450TJJaco Oil Co · Bakersfield, CAN451SDFortune Aviation LLC · Longview, TXN451SJTexas Mna LLC · Westlake, TXN452CFHangar LLC · Las Vegas, NVN452CKKalitta Charters LLC · Ypsilanti, MIN452LJLearjet Inc · Wichita, KSExpired dealerN452MPMed Air LLC · Lawrenceville, GAN452SDJet Quest LLC · Hunting Valley, OHN453AMN543am LLC · Englewood, CON454LCColumbia Asset Trust Corp Trustee · Wichita, KSN454MFCpc Aviation LLC · Bellaire, TXN454NBelle Air Leasing LLC · Wilmington, DEN455DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN455RCSolomon Mark Trustee · Wilmington, DEN456GSRueter Leasing LLC · Grand Junction, IAN45HFBoard Of Regents Of The Univ Of Nebraska · Lincoln, NEN45HGAsphalt Materials Inc · Indianapolis, INN45HKWalmart Inc · Bentonville, ARN45JACreamer Pilot Services LLC · Fayetteville, ARN45JGLearjet 45 LLC · Sellersburg, INN45JHSped Air LLC · Nashville, TNN45KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2012-16-14