AD 2016-08-20
Registered aircraft · 309
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:2016-08-20')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-20')
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:2016-08-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-20') 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.
N358AMAir Methods LLC · Greenwood Village, CON36SJAirbus Helicopters Inc · Grand Prairie, TXN382AMAir Methods LLC · Greenwood Village, CON388AMFirst-Citizens Bank & Trust Co · Morristown, NJN390AMAir Methods LLC · Greenwood Village, CON3WLWell Lived Mt LLC · Kalispell, MTN400AHAircraft Trustee Services Inc Trustee · Dover, DEN40AHAirbus Helicopters Inc · Grand Prairie, TXN410WAir Methods LLC · Greenwood Village, CON412RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN413RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN413UTMed-Trans Corporation · Denton, TXN414RXReach Air Medical Services LLC · Santa Rosa, CAN415RXReach Air Medical Services LLC · Santa Rosa, CAN41SHIndiana Helicopters LLC · Fort Wayne, INN425AMFirst-Citizens Bank & Trust Co · Morristown, NJN429RXReach Air Medical Services LLC · Santa Rosa, CAN430GRReach Air Medical Services LLC · Mcclellan, CAN431GRReach Air Medical Services LLC · Santa Rosa, CAN434UTFirst Citizens Bank & Trust Co · Morristown, NJN435UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN440RMRegional Air Medical Services Inc · Jasper, ALN456AEEurotec Vertical Flight Solutions LLC · Eudora, KSN45RSSpiegel Aviation LLC · North Palm Beach, FLN468PFFranklin Mountain Assets II LLC · El Paso, TXN470RGG350 Leasing LLC · Portland, ORN479DVDbd Properties LLC · Grand Rapids, MIN484FAFreedom Aviation LLC · Helena, MTN499DAWtj Capital Holdings III LLC · Vero Beach, FLN502GRAviation Trust Co LLC Trustee · Oklahoma City, OKN506LFAir Methods LLC · Greenwood Village, CON517LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN538FSBayou Skys LLC · Wilmington, DEN55GJCfa Holdings Inc · Knoxville, TNN577LFAir Methods LLC · Greenwood Village, CON5HAAshbaugh Hans · Elkhart, INN5SHIndiana Helicopters LLC · Fort Wayne, INN661AEAir Evac Ems Inc · O Fallon, MON662AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN667ALSouth America Tactical & Airborne Consulting Corp · Wilmington, DEN683MNArizona Law Enforcement Air Support · Sierra Vista, AZN684JBFl Jet LLC · Fort Myers, FLN699GCZuni LLC · Kirkland, WAN703ACAir Methods LLC · Greenwood Village, CON717CLR S Losee Helicopter Lc · Orem, UTN723PVN23pv LLC · Redondo Beach, CAN728AMAir Methods LLC · Greenwood Village, CON736AMAir Methods LLC · Greenwood Village, CON740AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN741ACAir Methods LLC · Greenwood Village, CO
Back to AD 2016-08-20