AD 2012-14-15
Registered aircraft · 832
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-14-15')
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-14-15')
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-14-15') 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-14-15') 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.
N23GMMain Line Executive Travel LLC · Haverford, PAN240PWOak Street Aviation LLC · Wichita, KSN242NGPanhandle Telecommunication Systems Inc · Guymon, OKN242SGReppert Capital Management LLC · Houston, TXN243TXTexas Department Of Public Safety · Austin, TXN244Eight Hills LLC · Seattle, WAN245HCHillsborough County Sheriffs Office · Tampa, FLN245PEReack Aviation LLC · Wilmington, DEN246ELTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN246SJSparkjoy Air LLC · Boulder, CON247AMRegistered aircraftN247CU283cu LLC · Gilcrest, CON247MKOoooia LLC · Marshalltown, IAN247SHUS Government · Washington, DCN248LMPilatus Aircraft USA Ltd · Broomfield, CON248MSPilatus Aircraft USA Ltd · Broomfield, CON249GXWildcat Aviation LLC · South Salt Lake, UTN24XZ31dodge Air LLC · Kernersville, NCN250KKNeed For Speed Aerospace LLC · Downers Grove, ILN251NGJa Investments Inc · Toledo, OHN254DLCrimson 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, CAN25XMMccluer Aviation LLC · North Las Vegas, NVN261HBChamonix Air LLC · Boulder, CON261NXCitizens National Bank Of Texas · Waxahachie, TXN264SGAdventaire LLC · Minot, NDN265NXCmr3 Holdings LLC · Newark, DEN266NGBlue Horizon Ventures LLC · Gadsden, ALN267PTBlades & Bars LLC · Montrose, CON269NGRebel One LLC · Dover, DEN26NGAgb Warranty Services LLC · Warrenton, VAN26WRWonderful Orchards LLC · Shafter, CAN26XMAm Aviation LLC · Henderson, NVN270AFRigi Inc · Portsmouth, NHN2710BDrglfg LLC · Denver, CON272NGCactus Land Development LLC · Fountain Hills, AZN276HDRussoms Cloud Server LLC · Montgomery, ALN278JMJlm Aviation LLC · Winthrop, MEN27KNStuckey Connections LLC · Magnolia, TXN27NXValiair Lc Trustee · Casper, WYN283AFJ3b LLC · Portsmouth, NH
Back to AD 2012-14-15