AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N302CPJbl Aviation Group Inc · Houston, TXN302JDNeoair LLC · Kingfisher, OKN302MCB & G Ventures LLC · Kalispell, MTN302RPMccollough Randy F · Belton, TXN302SRRebel Aviation LLC · Ramsey, MNN302TDFl370 LLC · Northbrook, ILN3030DBoardwalk Management LLC · Kalispell, MTN3031QBrut N3031q · Los Angeles, CAFirst renewal noticeN3032LBlue Sky Air Ventures LLC · Wilmington, DEN3033BPalms Edward M · Greenwood Village, CON3034CTyler Bonnie Flying LLC · Tyler, TXN3035WWorldwide Air & Sea Inc · Wilton, NHN30374Canihan William R · Novato, CAN303ABMarc Inc · Bolton, MSN303AWCirrus Design Corp · Duluth, MNN303BPMohan Anand · Vienna, VAN303CCSpectrum Aviation Inc · Wilmington, DEN303CGSolomon Mark Trustee · Wilmington, DEN303CMAdvantage Aviation Inc · Charlotte, NCN303DBBas Part Sales LLC · Greeley, CON303DCRegistered aircraftN303DKTrading Planes Inc · Wilmington, DEN303DWOredigger Air LLC · Highlands Ranch, CON303HLLao Che Airfreight LLC · North Weymouth, MAN303HVRegistered aircraftN303JPJep Inc · Clarksville, TNN303KDTablerock Aviation LLC · Mccall, IDN303KJBrother Michael Andrew · Bedford, TXN303KSSmoky Hill Ag LLC · Healy, KSN303LMRegistered aircraftN303PBPlane Fun Inc Tr Trustee · Snellville, GAN303SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303TTCoop Aero LLC · New Albany, MSN303ZZMartorello Aircraft Leasing LLC · Denver, CON3042V3 Pandas LLC · Farmington, NMN30453Lehman Land Management LLC · Vernon, TXN3045TRegistered aircraftN3045YMassee Donald R · Riverside, CAN3046DAldredge John F · Cornville, AZN3046KBas Part Sales LLC · Greeley, CON3049DAnchor Equipment Leasing LLC · Covington, KYN304DMDelta Mike Inc Trustee · Wilmington, DEN304WHLone Beech Enterprises LLC · Peachtree City, GAN30516J A Sutherland Inc · Ukiah, CAN30530Banegas Jose C Zankiz · Fort Myers, FLN3054ANocek Aviation LLC · Skaneateles, NYN3054RJamms Aviation LLC · Bedford, NHN3058ROn Top Aviation LLC · Salinas, CAN305APDoc Joey Inc · Wilmington, DEN305BCProp & Wing Aviation Inc · Humble, TX
Back to AD 2012-10-13