AD 2011-23-07
Registered aircraft · 219
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-23-07')
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-23-07')
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-23-07') 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-23-07') 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.
N705AKFamily Tree Farms Aviation LLC · Dinuba, CAN707MZAdams Aviation Services Inc Trustee · Wilmington, DEN707SQFreedom 200 LLC · Dallas, TXN710RHValiair Lc Trustee · Casper, WYN710TCCd 321 LLC · Austin, TXN716JWTango 280 Holdings LLC · Spring, TXN718CFMustang Equipment LLC · Dallas, TXN719KXKnight Air LLC · Phoenix, AZN721CCN721 Cc LLC · Lewes, DEN723RHRadco Aviation LLC · Atlanta, GAN726DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN730GAG150-Sn302 LLC · Cincinnati, OHN748QSJkp Enterprises Inc · Gainesville, FLN751BCInternational Bank Of Commerce · Laredo, TXN765MMacys Corporate Services LLC · Springdale, OHN765MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN765WMMcfly Air LLC · Downers Grove, ILN765WSMelex Rentals LLC · Delray Beach, FLN777FLAgnes LLC · Ashland, ORN777ZR671bp LLC · Dover, DEN7FFWestwind Air LLC · Champaign, ILN800PJRegistration Pending · Palo Alto, CARegistration pendingN802RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN811WKKovo Holdings LLC · Sugar Land, TXN812FTBizav Support LLC · Fort Lauderdale, FLN813HDSwcf Holdings LLC · Tampa, FLN817VCVeteran Airways LLC · Pooler, GAN819AMSiddons Martin Aviation LLC · Houston, TXN819VE60-206 LLC · Southlake, TXN850KRRichair Investments LLC · North Little Rock, ARN856T4ds LLC · Blaine, MNN860CBGolden Time Management LLC · Ogden, UTN861CBCb Aviation Inc · Ogden, UTN866GHk Aviation Corp · Wilmington, DEN868SCNickravesh Niknam · Saratoga, CAN876GHTvpx Ars Inc Trustee · North Salt Lake, UTN881HM881 Air LLC · Chicago, ILN881STTtdh200 LLC · Jacksonville, FLN8821CJvwl LLC · Woodland, CAN882MR882mr Mf Holdings LLC · Atlanta, GAN888Ajenat Holdings LLC · Washington, DCN8MFMf Air LLC · Wilmington, DEN901SSTwo Star Maritime LLC · Fremont, CAN902MMMar Aviation Sn072 LLC · Miami, FLN916GBY9 Inc · Jupiter, FLN917DPGalaxo LLC · Little Rock, ARN918SJNonstop Capital LLC · Newport Beach, CAN922LRCapital Holdings 210 LLC · Newark, DEN924KWApd Aero LLC · West Chicago, ILN925HBDodson International Parts Inc · Rantoul, KS
Back to AD 2011-23-07