AD 2018-21-13
Registered aircraft · 240
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:2018-21-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:2018-21-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:2018-21-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:2018-21-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.
N420EAHonda Aviation Service Co Inc · Greensboro, NCN420EXHonda Aviation Service Co Inc · Greensboro, NCN420FGDb Aviation LLC · Bowling Green, KYN420GEMcc Hj LLC · Saint Louis, MON420GHHonda Aviation Service Co Inc · Greensboro, NCN420HBVolato 158 LLC · Chamblee, GAN420HFHonda Aviation Service Co Inc · Greensboro, NCN420HHHonda Aviation Service Co Inc · Greensboro, NCN420HJHonda Aviation Service Co Inc · Greensboro, NCN420HMHonda Aviation Service Co Inc · Greensboro, NCN420HNHonda Aviation Service Co Inc · Greensboro, NCN420HXHonda Aviation Service Co Inc · Greensboro, NCN420KARecovery Aviation LLC · Natchez, MSN420KYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN420LDLewco Air LLC · Baton Rouge, LAN420LGLeavitt Group Wings LLC · Cedar City, UTN420LHEastern Aircraft 420lh LLC · Gladwyne, PAN420LJHonda Aviation Service Co Inc · Greensboro, NCN420LRTpc Aviation LLC · Saint Louis, MON420MXTa Aircraft Services LLC · Winter Park, FLN420NCRegistered aircraftN420NJGenerational Jetsetters LLC · Sumter, SCN420NMHonda Aviation Service Co Inc · Greensboro, NCN420NWSolera Aviation LLC · Bozeman, MTN420NYHonda Aviation Service Co Inc · Greensboro, NCN420PPAssociated Terminals LLC · Newark, DEN420RPBeaux Eden Aviation LLC · Atlanta, GAN420STS T Lease-It LLC · Simi Valley, CAN420TNHonda Aviation Service Co Inc · Greensboro, NCN420TTRegistered aircraftN420UTNulton Enterprises LLC · Johnstown, PAN420VTHonda Aviation Service Co Inc · Greensboro, NCN420WVHonda Aviation Service Co Inc · Greensboro, NCN420XEGalleria Air LLC · Camden, DEN420XXTl Flights II LLC · Thomasville, GAN420ZFHonda Aviation Service Co Inc · Greensboro, NCN420ZGHonda Aviation Service Co Inc · Greensboro, NCN421EKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN422KTRegistered aircraftN426DHUtah Gas Corp · Houston, TXN426HJManifest Aviation LLC · Winter Park, FLN42HSValiair Lc Trustee · Casper, WYN430DCIoptimize Realty Inc · Commack, NYFirst renewal noticeN430EGalilee III Spv LLC · Bozeman, MTN430HJCruse Aviation LLC · Lafayette, LAN430NWHonda Aviation Service Co Inc · Greensboro, NCN440HJHonda Aviation Service Co Inc · Greensboro, NCN470TWGilbert Development Corporation · Hurricane, UTN482PGTdz Global Leasing LLC · Houston, TXN483MPAvex Vi Corp · Fort Lauderdale, FL
Back to AD 2018-21-13