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.
N345MJM & M Aero LLC · Half Moon Bay, CAN345PGN345pg LLC · Chicago, ILN345PKWatch Ya Head Aviation I LLC · Zionsville, INN345TFWilkinson Mark A · Lincoln, MAN345TSUncle Bob Consulting LLC · Antioch, ILN345USAvion Solutions Group LLC · Apex, NCN345WLMillionair Ride LLC · San Antonio, TXN345WZEntroair LLC · Hilliard, OHN345XWjd Aviation LLC · Gadsden, ALN346CHAce Flight Center Inc · St Thomas, VIN346DWValiair Lc Trustee · Casper, WYN346ENorth Coast Aeronautical LLC · Cleveland, OHN346FSRichard C Reed · Snyder, TXN346MCSkyway Aviation LLC · Purvis, MSN346RNSchroll Charles E · Tucson, AZN3473GThayer John P · Columbus, GAN347AAci Aviation Holdings LLC · Abbeville, LAN347ABTropical Transport Services Ltd Inc · San Juan, PRN347CDCulkin Daniel J Trustee · Edmond, OKN347CPNwr Aviation LLC · Scottsdale, AZN347DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN347JADepete Joseph G · Louisville, KYN347SRVenture North Aviation LLC · Cloquet, MNN348ATCharitable Giving Center · Las Vegas, NVN348BWRegina Miller Group Inc · Santa Monica, CAN348CD348 Charlie Delta LLC · Ames, IAN348LCChannel Larry E · Las Cruces, NMN348SBVector Victor Aviation LLC · Geneva, ILN348TSTuchman Holdings LLC · Englewood, NJN3494QRodcon Aircraft Sales LLC · Kalispell, MTN349RFPhase 2 Ventures LLC · Seattle, WAN349RPMiranda Gary R · Vancouver, WAN34ADPremiere Aviation Inc · Concord, CAN34AHElastapro Silicone Sheeting LLC · Santa Fe Springs, CAN34ALVy Strategies LLC · Dublin, GAN34AWValiair Lc Trustee · Casper, WYN34BTWilliams Charles R · Wadsworth, OHN34CDCannon David A · Magnolia, TXN34CKJaycox Chad Trustee · Venice, FLN34DBRegistered aircraftN34FRFront Runner Capital LLC · Newark, DEN34GCPhillips Stuart G · Woodside, CAN34KBReilly Donald H · Micco, FLN34KFRsb Properties LLC · Lewes, DEN34KMBravo Adventures LLC · Scottsdale, AZN34NYKeys Robert · Menifee, CAN34RInfinity Welding And Fabrication LLC · Celina, TXN34TGTri W Inc · Shepherd, MTN34TLAmeagle Aviation LLC · Coventry, CTN34TNCirrus Sr22t 10713 Inc Owner Trustee · Wilmington, DE
Back to AD 2012-10-13