AD 98-11-13
Registered aircraft · 284
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:98-11-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-11-13')
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:98-11-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-11-13') 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, DEN718RRMac 800xp LLC · Wilmington, DEN719HGFlightworks Inc · Kennesaw, GAN71AHAircraft Holding Solutions LLC Trustee · Newark, DEN724JLAmeri Hawk Investments LLC · Lorton, VAN726LCN726lc LLC · Amarillo, TXN729ATN88ca III LLC · Stuart, FLN72FCAlliance Aviation Group LLC · Wilmington, DEN72HAMcn Aviation Partners LLC · Charlestown, INN740TTValiair 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, DEN780DWBemo23 Assembly LLC · New York, NYN789HAClark County Jets LLC · Sellersburg, INN793RCLfg Aviation Holdings LLC · Kalispell, MTN799RMBank Of Utah Trustee · Salt Lake City, UTN799SN143bl LLC · Hixson, TNN79TSTasair LLC · Minocqua, WIN800EASalt Whistle LLC · Newark, DEN800GNJaunt Jet LLC · Spring, TXN800LQAdc Aviation LLC · Birmingham, ALN800MAMarco Aviation LLC · Nazareth, PAN800NGClear Horizons LLC · Greenwood Village, CON800NJGlobal Empire Trust LLC · Fort Lauderdale, FLN800PEFour C Air Inc · Delano, CAN800PLN800pl LLC · Fort Lauderdale, FLN800THHoover Aviation LLC · Nashville, TNN800TLN800tl LLC · Wilmington, DEN800UKJ W Construction Co Inc · Wise, VAN800UWUniform Whiskey Holdings LLC · Opa Locka, FLN800WFVarsity Aviation LLC · Martinsburg, PAN800WWPnw Transport LLC · Tucson, AZN800XMFlyteme Aviation LLC · Fort Pierce, FLN800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLN802CFLitton Global LLC · Wilmington, DEN804BHMahaska Bottling Co · Oskaloosa, IAN804JMStarr Aviation Solutions LLC · New York, NYN804MC824 Holdco LLC · Salt Lake City, UTN804TBN804tb III LLC · Stuart, FLN806GJPb Air LLC · Higley, AZN806MNJm Soar LLC · Paradise Valley, AZ
Back to AD 98-11-13