AD 2000-08-07
Registered aircraft · 369
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-08-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:2000-08-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:2000-08-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:2000-08-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.
N707BMLft Properties LLC · Mayfield Heights, OHFirst renewal noticeN707JQPinnacle Aviation Group LLC · Wilmington, DEN709LPPilgrim Air LLC · Van Nuys, CAN710HRAsf Aviation LLC · Cortlandt Manor, NYN715LALongbow Aviation LLC · Fernandina Beach, FLN716DBCervenka Debra A · Santa Rosa Beach, FLN717KVN717kv LLC · Wilmington, DEN717MTAircraft Holding Solutions LLC Trustee · Newark, DEN718HCAcme Leasing II LLC · Nashville, TNN718LFJet Geeks Aviation Maintenance Inc · Teterboro, NJN718RRMac 800xp LLC · Wilmington, DEN719HGFlightworks 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, INN732AADjcj LLC · Nashville, TNN740TTValiair Lc Trustee · Casper, WYN745MCMiradair LLC · Lake George, NYN746TXSierra Aviation Holdings LLC · Colorado Springs, CON749WWSmf Ohio LLC · Lakewood, NJN770CCTaughannock Aviation Corp · Ithaca, NYN771FMCf Aviation Trust LLC Trustee · Wilmington, DEN778RMAero 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, FL
Back to AD 2000-08-07