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.
N792JCAir Jordan LLC · Natchez, MSN798NHPropertyco LLC · Eugene, ORN800RDPinnacle Aviation LLC · New York, NYN809CNAllen Air LLC · Creola, ALN809GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN815JJMsh Leasing LLC · Thomasville, GAN815RMRomalou LLC · Fort Lauderdale, FLN816JDMci Rentals Lc · North Bay Village, FLN818ATwin Flyers LLC · Alpharetta, GAN820JLLaminar Holdings LLC · Katy, TXN824GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN826EAndy Leavitt Enterprises LLC · North Bend, ORN827HJHonda Aviation Service Co Inc · Greensboro, NCN829DLFrayer Jets 4 LLC · Oklahoma City, OKN829LRHonda Aviation Service Co Inc · Greensboro, NCN82DGPilotdaria LLC · Big Pine Key, FLN82HMH & M Bay Inc · Federalsburg, MDN82PWendell Shawn · Houston, TXN83NCFairway Capital Partners Inc · Greensboro, NCN843JTMuncie Aviation Co · Muncie, INN856WD16th Fairway Air LLC · Tulsa, OKN85NUGsp 75 LLC · Grand Haven, MIN862DWJackson Executive Transport LLC · Jackson, MIN875JPBoyd Aviation Pv LLC · Saint Augustine, FLN878HJLuxsol LLC · Laredo, TXN87HJAviation Industries LLC · Aurora, ILN894LLJlp Group LLC · Baton Rouge, LAN903THLight Moon LLC · Newton, ALN909BPGsh Travel LLC · Oklahoma City, OKN90CWSpring Leasing LLC · Mobile, ALN913JTS&S Contractors LLC · Leitchfield, KYN918AJetko LLC · Boston, MAN949LLRcn Aviation LLC · Missoula, MTN94EFKipo LLC · Harahan, LAN959AHAmerican Honda Motor Co Inc · Greensboro, NCN95NUCsc Delaware Trust Co Trustee · Wilmington, DEN97ZTHonda Aviation Service Co Inc · Greensboro, NCN992WSRe Wdc Inc · Maitland, FLN999JBSilverleaf V LLC · Scottsdale, AZN999LLSky Access LLC · San Juan, PR
Back to AD 2018-21-13