AD 2019-08-13
Registered aircraft · 1,554
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:2019-08-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:2019-08-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:2019-08-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:2019-08-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.
N300HFMorgan Aviation Leasing LLC · Knoxville, TNN300JWAviate LLC · Greensboro, NCN300MVMaverik Inc · Salt Lake City, UTN302CJN302cj LLC · Springfield, MON302JKCrt Air LLC · Mentor, OHN303KMCoastal Rentals LLC · Allen, KYN304BPIntermountain Air Inc · Colorado Springs, CON304TCCanyons Aviation Group LLC · Orlando, FLN304TXNlw Inc DBA · Indianapolis, INN305KCRegistered aircraftN306CJRegistered aircraftN307LJJd One Third LLC · Houston, TXN307PEN307pe LLC · Irvine, CAN308CMCattlemen Logistics LLC · Minden, NEN308GTSan Joaquin Refining Co Inc · Bakersfield, CAN308NJ22ase LLC · Aspen, CON309CJJe Air LLC · Byron Center, MIN30BPLkh Group LLC · Naples, FLN30CJR K B Inc · Portland, ORN30DESunskies Aviation LLC · Bakersfield, CAN30GXBell Avenue Aviation LLC · Des Moines, IAN30KMRefreshed 0110 LLC · Dover, DEN30LAAerokb LLC · Wilmington, DEN30MSkysouth Aviation Inc · Durham, NCN30NMTextron Aviation Inc · Wichita, KSN30NSHilltop LLC · Rye, NYN30STStreet Aviation LLC · Naples, FLN30VRWd Journeys Inc · Downers Grove, ILN310EGWhite Pine Two LLC · Park City, UTN310GTGt Carriers Aircraft LLC · Bakersfield, CAN311CPKwihnai Flyers LLC · Troy, OHN311SRIsr Aviation LLC · Wilmington, DEN313WLPeak Aviation LLC · Royal Oak, MIN315CJFlagship Private Air LLC · Belleville, MIN315HCHooper Holdings LLC · Madison, WIN3168N3168 LLC · San Antonio, TXN316BDM2mo LLC · Saint Louis, MON316PJWmj Aviation LLC · Wilmington, DEN317TXRegistered aircraftN318CGSvp LLC · Missoula, MTN318JHAir Hoffmann LLC · Saint Louis, MON318JPSurric LLC · Shreveport, LAN319JDHollingsworth Intergalactic LLC · Clinton, TNN31CJ212 Investments Of Montana LLC · Collinsville, OKN31HAHampden Aviation Services Inc · Florence, MAN31HDHotel Delta LLC · Sacramento, CAN31SPBank Of Utah Owner Trustee · Salt Lake City, UTN31WEWorldwide Equipment Of Tn Inc · Knoxville, TNN320CJCeejay LLC · Parker, CON321EMRiomar Sky LLC · Warrington, PA
Back to AD 2019-08-13