AD 98-15-13
Registered aircraft · 2,358
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-15-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-15-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-15-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-15-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.
N298CFRichmond Investments Inc · Wilmington, DEN299AVTeton Leasing LLC · Pocatello, IDN299KPGrubb Allen · Fresno, CAN299MKBoman & Kemp Manufacturing Inc · Ogden, UTN299RPGuardian Flight LLC · Lewisville, TXN299VMSs Leasing LLC · Tulare, CAN29MBluesky Geospatial Ltd · North Adams, MAN29PENv5 Geospatial Inc · Sheboygan Falls, WIN29VKV-Jet Aircraft Holding Co Trustee · Dover, DEN29VRV-Jet Aircraft Holding Co Trustee · Dover, DEN29VSV-Jet Aircraft Holding Co Trustee · Dover, DEN2DBKa300 LLC · Greenwood Village, CON2GGN2gg Leasing LLC · Ponca City, OKN2UVDependable Freight LLC · Bethel, AKN2UWUniversity Of Wyoming · Laramie, WYN2VACommonwealth Of Virginia · Richmond, VAN300AJAsm Aviation LLC · Bismarck, NDN300AWDavis Aviation Inc DBA · Brandon, MSN300CWDome Aviation LLC · Loomis, CAN300DMLas Montanas Aviation LLC · Oro Valley, AZN300KAHeartland Aviation LLC · Ada, OKN300KLPeddinghaus Corp · Bradley, ILN300MCHighway 16 Ranch LLC · Corpus Christi, TXN300PLPolaris Industries Inc · Medina, MNN300PTGjf Enterprises Inc · Port Orange, FLN300SEJetx Air LLC · Camden, DEN300SPSamaritans Purse · Boone, NCN300TAMarshmont Aviation LLC · Greenville, SCN300TEKingair 61 LLC · Wilmington, DEN300TMTaylor & Martin Enterprises Inc · Fremont, NEN300TNWild Blue Aviation LLC · Wilmington, DEN300VAAeon62 Holdings LLC · Plano, TXN300WMWalker Manufacturing Co · Fort Collins, CON300WQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN301CWSky 005 LLC · Colorado Springs, CON301PTDenaina Leasing Agency LLC · Anchorage, AKN301TSNeptune Aviation Services Inc · Missoula, MTN302CGKiowa Turbine LLC · Galesburg, ILN302PSF90x LLC · Modesto, CAN3030GDutch Aviation LLC · Perry, IAN303CAM&H Flight Services LLC · Kerrville, TXN303RRG2 Leasing LLC · Fargo, NDN304DEGreen Flash Aviation LLC · Audubon, IAN304JSRegistration Pending · Pharr, TXRegistration pendingN304SHJaimlubec LLC · Austin, TXN3051KBuilding Corp LLC · Huntsville, TXN305ELRoper Aviation LLC · Wilmington, DEN305LGEaglemed LLC · Wichita, KSN305SAIndigo Blue Aviation LLC · Spartanburg, SCN305TTZulu Air LLC · Opa Locka, FL
Back to AD 98-15-13