AD 2016-15-05
Registered aircraft · 588
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:2016-15-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-15-05')
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:2016-15-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-15-05') 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.
N269PHPruitt Tran II LLC · Norcross, GAN26SMTricor Aviation LLC · Winter Park, FLN272FCBest Aviation Inc · Baldwin, GAN273LXFrist Aviation LLC · Nashville, TNN273SWRegistered aircraftN274SGFree Bird Flight Ops LLC · Newport Beach, CAN275SWRegistered aircraftN278RFGlenbrook III LLC · San Jose, CAN279SWRegistered aircraftN27FJAviation Resource Group Inc · Ft Lauderdale, FLN2828Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN286MJHc Logistics LLC · Chicago, ILN291MJTequila Mockingbird LLC · New York, NYN298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTN2NLCenturion Investments Inc · Chesterfield, MON301MTRegistered aircraftN303CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303TFNtc Aviation LLC · Greenwich, CTN304KSonic Automotive Inc · Charlotte, NCN307MDN307md LLC · Barrington, RIN30HQLearjet Inc · Wichita, KSN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DEN313RHRedwood Holdings LLC · Hanover, MDN313STIota Aviation LLC · Bloomfield Hills, MIN313WATvpx Trust Co LLC Trustee · North Salt Lake, UTN315REGrey Goose LLC · Pleasant Prairie, WIN317MLMds Falcon LLC · Kittanning, PAN321AJM Hixson Aviation LLC · Denton, TXN321AKSnails Pace Aviation LLC · New York, NYN321APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN3221BAurum Aviation LLC · Dallas, TXN322FJRegistered aircraftN323SEWard Ohara Companies LLC · Kansas City, MON324SLAp Aviation LLC · Troy, VAN326EWLeco Corp · South Bend, INN3278Peregrine Falcon LLC Trustee · Boise, IDN327LXBoston Post Leasing LLC · Nashua, NHN327RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN331DCBlue Bird Adventures LLC · Springfield, TNN333MXHappy Travels LLC · Whitefish, MTN338MJ A Real Estate Investments LLC · Fort Lauderdale, FLN33BGBoyd Gaming Corp · Las Vegas, NVN33VCSilver Lake Aviation LLC · Park City, UTN341APAircroft LLC · Sarasota, FLN34PCPace Falcon Leasing LLC · Plymouth, MIN34VHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN351MARugby Transit LLC · Boca Raton, FL
Back to AD 2016-15-05