AD 96-09-13
Registered aircraft · 772
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:96-09-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:96-09-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:96-09-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:96-09-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.
N389RAAirtrex Aircraft Xray Inc · Wichita, KSN38JVKcsi Aerial Patrol Inc · Bakersfield, CAN38VSNv5 Geospatial Inc · Sheboygan Falls, WIN390PMPlanemasters Ltd · West Chicago, ILN390RHAlpine Aviation Inc · Provo, UTN390SPState Of Arkansas · Little Rock, ARN395AMHollan Air LLC · Amarillo, TXN396MFRango Aviation LLC · Mesa, AZN399ALBallard Aviation Inc · Newton, KSN399CZN399cz LLC · Milwaukee, WIN39TNDenaina Leasing Agency LLC · Anchorage, AKN39UBAmeriflight LLC · Dallas, TXN3MHN3mh LLC · Kalispell, MTN3NCNorth Carolina Dept Transportation · Raleigh, NCN3PXAirtime LLC · Mont Belvieu, TXN400GWGpw LLC · Laurel Springs, NCN400SCN400sc LLC · Walterboro, SCN4053HCosmos Holdings Group LLC · Newark, DEN405PTDodson International Parts Inc · Rantoul, KSN408SNUS Department Of State · Melbourne, FLN410RTStewart Aviation Services LLC · Birmingham, ALN411CCSunshine Aviation LLC · Roseburg, ORN411KCPonderosa Aviation LLC · Safford, AZN411WAGuardian Flight LLC · Lewisville, TXN415TMCrouch Aire LLC · Westcliffe, CON416MMTj Air Holdings Inc Trustee · Wilmington, DEN418JCsk Aviation Partners LLC · Fort Smith, ARN418LCAlpine Aviation Inc · Provo, UTN4222ATenax Air LLC · Ridgeland, MSN422AXAlpine Aviation Inc · Provo, UTN423EMEaglemed LLC · Wichita, KSN424TTTja Aviation LLC · Miami, FLN425BPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN426SDBering Strait School District · Unalakleet, AKN427GCTouch And Go Aviation LLC · Jackson, MNN428MCRfc Aviation LLC · Laurel, MSN4299AUas Transervices Inc · Boca Raton, FLN429EMEaglemed LLC · Wichita, KSN42FCN42fc Leasing LLC · Ponca City, OKN430DDN430dd LLC · Athens, TXN430SN430s LLC · Mesa, AZN431SCJochl Sports Inc · Banner Elk, NCN433HCKrabby Apple Trading LLC · Wilton, CTN433JMN433jm LLC · Dallas, TXN436EAN436ea LLC · Sanford, FLN437WFHewitson Enterprises Inc · Avenal, CAN438FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN442PLBank Of Utah Trustee · Salt Lake City, UTN444KASky Hye Air LLC · Hye, TXN444LPTri Supply LLC · Beaumont, TX
Back to AD 96-09-13