AD 2012-22-01
Registered aircraft · 3,852
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-22-01')
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-22-01')
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-22-01') 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-22-01') 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.
N197BALewis University · Romeoville, ILN197MCLewis University · Romeoville, ILN197MEPremier Air Of Delaware Inc · Flemington, NJN197TACoast Aviation LLC · Costa Mesa, CAN198BWFixed Wing Holding Co Inc · Pembroke Pines, FLN198MECal Aggie Flying Farmers · Davis, CAN198PGSun City Aviation LLC · Davie, FLN198SPFlight Training Aircraft LLC · Wilmington, DEN198THWingsleasing LLC · Wichita, KSN1998FSpartan Education Group LLC · Tulsa, OKN1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CAN199SPW Air LLC · Wheeling, ILN19MVSky Path Aviation LLC · Sheridan, WYN2000CTextron Aviation Inc · Wichita, KSN2004UEpic Aviation Inc · Denison, TXN20067Epic Aviation Inc · Denison, TXN2007XEpic Aviation Inc · Denison, TXN2012FEpic Aviation Inc · Denison, TXN2013WEpic Aviation Inc · Denison, TXN2016FEpic Aviation Inc · Denison, TXN201ELAa-Aero LLC · Lewes, DEN201FSRegistration Pending · Peoria, AZRegistration pendingN201KSKing Aircraft LLC · San Diego, CAN201THG & M Aircraft Inc · Wheat Ridge, CON201TWTom Wood Aviation Inc · Fishers, INN201WLWingsleasing LLC · Wichita, KSN202AJEnterprise Aviation Services LLC · Albuquerque, NMN202CPCivil Air Patrol · Maxwell Afb, ALN2030CSky Bear LLC · Lakewood, CAN203CPCivil Air Patrol · Maxwell Afb, ALN203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeN20401Atpce LLC · Wilmington, DEN20412Atpce LLC · Wilmington, DEN20417Atpce LLC · Wilmington, DEN20422Atpce LLC · Wilmington, DEN20425Atpce LLC · Wilmington, DEN2046KChristiansen Aviation LLC · Wilmington, DEN20502Atpce LLC · Wilmington, DEN20519Skyhawk Leasing LLC · Mccordsville, INN2052VBlue Sky Personnel Services LLC · Coushatta, LAN20537Atpce LLC · Wilmington, DEN20549Atpce LLC · Wilmington, DEN2054SLewis University · Romeoville, ILN2055RWnc Aviation LLC · Arden, NCN20564Atpce LLC · Wilmington, DEN20566Atpce LLC · Wilmington, DEN20597Hk Aircraft Leasing LLC · Lititz, PAN205FGRidgeline Assets LLC · Wilmington, DEN205HCGulf Coast Aviation LLC · New Orleans, LAN2060UJade Air LLC · Lomita, CA
Back to AD 2012-22-01