AD 2000-22-03
Registered aircraft · 425
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:2000-22-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-03')
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:2000-22-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-22-03') 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.
N719HGFlightworks Inc · Kennesaw, GAN71AHAircraft Holding Solutions LLC Trustee · Newark, DEN724GPJawad A Shah Md Pc · Flint, MIN724JLAmeri Hawk Investments LLC · Lorton, VAN726LCN726lc LLC · Amarillo, TXN728HHNevarez Julio · Brownsville, TXN729ATN88ca III LLC · Stuart, FLN72FCAlliance Aviation Group LLC · Wilmington, DEN72HAMcn Aviation Partners LLC · Charlestown, INN730CJN730cj LLC · Williamsburg, VAN732AADjcj LLC · Nashville, TNN740TTValiair Lc Trustee · Casper, WYN745MCMiradair LLC · Lake George, NYN746TXSierra Aviation Holdings LLC · Colorado Springs, CON7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN749WWSmf Ohio LLC · Lakewood, NJN770CCTaughannock Aviation Corp · Ithaca, NYN770RGAir Mccormack LLC · Chicago, ILN771FMCf Aviation Trust LLC Trustee · Wilmington, DEN777EHMilligan Michael Zachery · Reno, NVFirst renewal noticeN778RMAero Advantage Services Corp Trustee · Wilmington, DEN780DWBemo23 Assembly LLC · New York, NYN789HAClark County Jets LLC · Sellersburg, INN793RCLfg Aviation Holdings LLC · Kalispell, MTN798PAJli Holdings Group Inc · Johns Island, SCN799RMBank Of Utah Trustee · Salt Lake City, UTN799SN143bl LLC · Hixson, TNN79TSTasair LLC · Minocqua, WIN800AFJec Hawker LLC · Pflugerville, TXN800CJCdmr Pj LLC · Jackson, NJN800EASalt Whistle LLC · Newark, DEN800EGAircraft Trustee Services Inc Trustee · Dover, DEN800FJAstra Aircraft Holdings Corp · Wilmington, DEN800GNJaunt Jet LLC · Spring, TXN800JMGreen Chair Productions Inc · Wichita Falls, TXN800LQAdc Aviation LLC · Birmingham, ALN800MAMarco Aviation LLC · Nazareth, PAN800NGClear Horizons LLC · Greenwood Village, CON800NJGlobal Empire Trust LLC · Fort Lauderdale, FLN800PAVance And Priscilla Hinton LLC · New Braunfels, TXN800PEFour C Air Inc · Delano, CAN800PLN800pl LLC · Fort Lauderdale, FLN800RGRm13 Air LLC · Wellington, FLN800SEDodson International Parts Inc · Rantoul, KSN800SVAircraft Fidelity Corp Trustee · Dover, DEN800THHoover Aviation LLC · Nashville, TNN800TLN800tl LLC · Wilmington, DEN800UKJ W Construction Co Inc · Wise, VAN800UWUniform Whiskey Holdings LLC · Opa Locka, FLN800VRCkv Express LLC · Minneapolis, MN
Back to AD 2000-22-03