AD 2002-23-20
Registered aircraft · 384
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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.
N361KBpcp Falcon N361k LLC · Wilmington, DEN3712CF900ex LLC · Minneapolis, MNN373RSKalamazoo Group II LLC · Kalamazoo, MIN382KUMaverick Aire LLC · New Castle, CON387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN38TVLs Mobile LLC · Weatherford, TXN39NPWilmington Trust Co Trustee · Wilmington, DEN400THDuke Vacation LLC · Wilmington, DEN401GJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404FWcf Aircraft LLC · Detroit, MIN405EKArlington Aircraft Of Nevada LLC · Sun Lakes, AZN40LBFirst Premier Corp · Sioux Falls, SDN411CDRegistered aircraftN412ECBank Of Utah Trustee · Salt Lake City, UTN416KCSpenaero Lc · Salt Lake City, UTN41MBRivers Equipment LLC · Nashville, TNN420PDKms Air LLC · West Bend, WIN424UAeronavis LLC · Wilmington, DEN425RJFant Aircraft Enterprises LLC · Houston, TXN428DRMaverick Air II LLC · Deer Park, WAN42NFCest La Vie LLC · Piedmont, OKN440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44VPGable S Corp · West Linn, ORN450FVYellowdome LLC · Emigrant, MTN469SSDeez-Nuts LLC · Goodlettsville, TNN46HBSunshining Aviation LLC · Wilmington, DEN46RBaci LLC · Portland, ORN47EGWing And Rotor Transportation Holdings LLC · Morristown, NJN484FMV1vr LLC · Wilmington, DEN488MHSmyrna Ready Mix Concrete LLC · Nashville, TNN48CGCorning Inc · Corning, NYN48KZN48kz LLC · Long Beach, CAN493CFShamrock Air LLC · Baltimore, MDN499MHHollingshead Aviation Services LLC · Murfreesboro, TNN4BAMonte Carlo Associates LLC · Santa Ana, CAN4DFCds Equipment LLC · Cincinnati, OHN4SM4sm LLC · West Palm Beach, FLN4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN500BLBnb LLC · Wilmington, DEN500JJUltimate Human Aviation LLC · Coconut Grove, FLN504PASmee Homes Inc · Porterville, CAN504STSdt Air Delaware LLC · Wilmington, DEN508MMMarklyn Jet Parts LLC · Dallas, TXFirst renewal noticeN50LBRegistered aircraftN510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN510RHHms Holdings LLC · Charlotte, NCN512KSMcreynolds Aviation LLC · Dallas, TXN513HSRanch Stadium Equipment Leasing Inc · Dallas, TXN515MFAh Jag LLC · Atlanta, GAN516JAKings Aviation Corp · Garden City, NY
Back to AD 2002-23-20