AD 2018-07-16
Registered aircraft · 282
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-07-16')
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-07-16')
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-07-16') 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-07-16') 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.
N246CFArq Aviation LLC · Wilmington, NCN251JMStoney Creek Aviation LLC · Houston, TXN251SAA Tail Of Two Cities LLC · Elkhart, INN257LAAa Aviation LLC · Nashville, TNN25HSSkyline Aviation Inc · San Angelo, TXN262GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN264LAOntario Holdings LLC · Sheridan, WYN265LAJk Aviation LLC · Knoxville, TNN265PSMyflight Five LLC · Lake Mary, FLN267PSBerlet Consulting LLC · Odessa, FLN269LASanstone Management Company LLC · Arden, NCN271CFWind Rising Ventures LLC · Columbus, MSN272DD2dd Aviation LLC · Lafayette, CAN272MBYankee Lima One LLC · Bolingbrook, ILN276LANext Stop Mars LLC · Hartwell, GAN27SJ0x1b LLC · Brooklyn, NYN296LANterjet LLC · Sheridan, WYN296SKAlf Ix LLC · Chicago, ILN2DKClausen Frederik M · Chicago, ILN301RHQualitair LLC Trustee · MichelstadtN302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN303SWSkywarrior Flight Training LLC · Pensacola, FLN304SWSkywarrior Flight Training LLC · Pensacola, FLN305EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN306EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN308EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN309EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN310XAJetnexa Ten LLC · Gilbert, AZN311EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN311LHWingsleasing LLC · Wichita, KSN312EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN313EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN314EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN3150AOklahoma Aviation LLC · Bethany, OKN315XAJetnexa Thirteen LLC · Gilbert, AZN316JZZockoll Janice M · Hudson, OHN318EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN319EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN320AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN320EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN322EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN323EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN324EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN327EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN328EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN329EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN32GH1 Diamond 62 LLC · Santa Fe, NMN331JSStaniforth James A · Tehachapi, CAN3364ZBellfask LLC · Paris, TXN33KFKermitflies LLC · Bend, OR
Back to AD 2018-07-16