AD 2011-22-01
Registered aircraft · 1,167
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:2011-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:2011-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:2011-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:2011-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.
N507VJTvpx Trust Co LLC Trustee · North Salt Lake, UTN508CKIbc Hospitality LLC · Newport Beach, CAN50JEIn50je LLC · New York, NYN50KUUnder The Stars LLC · Millington, TNN50SRegistered aircraftN50VCBoulder Haven LLC · Dallas, TXN50WHWhite Wing Holdings LLC · Waukegan, ILN510GTSouthwest Associates LLC · Bigfork, MTN510GVTtp Services LLC · Hillsborough, NCN510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN510SRRelated 2019 LLC · New York, NYN511DBSkybird Aviation Inc · Newport Beach, CAN513DLPnc Financial Services Group Inc · Pittsburgh, PAN513MARichport Air LLC · Miami, FLN513TFEac Air LLC · New York, NYN514NBAlten Consulting LLC · Fort Lauderdale, FLN515KAWilmington Trust Co Trustee · Wilmington, DEN515MJFleet Two LLC · Beverly Hills, CAN516GHMadero Air LLC · South Saint Paul, MNN516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN517DWColleen Corp · New Castle, DEN517TWGtw Corp · Jupiter, FLN518DDDcs Aviation LLC · Dallas, TXN518GAL3harris Technologies Flight Capital LLC · Greenville, TXN518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLN519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN51SETps LLC · Medina, WAN51VETrousdale Aviation LLC · West Hollywood, CAN521GAGulfstream Aerospace Corp · Savannah, GAN521SBBank Of Utah Trustee · Salt Lake City, UTN522GDL3harris Technologies Flight Capital LLC · Greenville, TXN524ACPegasus Leasing LLC · Ada, MIN524AGTvpx Ars Inc Trustee · North Salt Lake, UTN524VEBank Of Utah Trustee · Salt Lake City, UTN526EMEmi Travel LLC · Tampa, FLN526GAL3harris Technologies Flight Capital LLC · Greenville, TXN526SDWilmington Trust Co Trustee · Wilmington, DEN527GAL3harris Technologies Flight Capital LLC · Greenville, TXN527JGGibbs International Inc · Spartanburg, SCN528APArrow Plane Lc · Provo, UTN528MPCr Holdings LLC · Crystal Lake, ILN529GAL3harris Technologies Flight Capital LLC · Greenville, TXN529RLRegistered aircraftN530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXN530KCRegistered aircraftN530PMEbts LLC · New York, NYN531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXN532SPGulfstream Leasing LLC · Savannah, GAFirst renewal noticeN533GVWilmington Trust Co Trustee · Wilmington, DEN535VDelaware Aircraft Trust LLC Trustee · New Castle, DE
Back to AD 2011-22-01