AD 2005-12-13
Registered aircraft · 479
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:2005-12-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:2005-12-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:2005-12-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:2005-12-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.
N600THN600th LLC · Fredericksburg, VAN607JDJd 707 Air LLC · Edgerton, OHN6161ZSkybound Holdings LLC · Orlando, FLN616STK&S Flights LLC · Sweet Valley, PAN618CAHyannis Air Service Inc · Hyannis, MAN625JLTurbulent Returns LLC · Minneapolis, MNN628JWJuliet Whiskey LLC · Roanoke, VAN635MAAirswiss Inc · Wilmington, DEN63DBDelta Properties Llp · Nogales, AZN643WMBarham Investments LLC · Dexter, MON650BDV1vr LLC · Saint Louis, MON650DBValiair Limited Company Trustee · Casper, WYN650RMAcci Aviation LLC · Conway, ARN6561CTrtc Aviation LLC · Byron Center, MIN6578CPapoose Air II LLC · Wilmington, DEN6597CHai Services Inc · Haltom City, TXN65RPE-Co Aviation LLC · Wilmington, DEN660CABank Of Utah Trustee · Salt Lake City, UTN6614CBg Air Corp · Wilmington, DEN6631CD Porter Enterprises LLC · Dickinson, NDN663AAHyannis Air Service Inc · Hyannis, MAN6640CGospel Ministries International Inc · Collegedale, TNN6672CBayview Direct LLC · Dover, DEN675RVb Flying LLC · Cornelius, NCN6765THyannis Air Service Inc · Hyannis, MAN677CAHyannis Air Service Inc · Hyannis, MAN67886Hyannis Air Service Inc DBA · Hyannis, MAN678HDawson Aircraft Inc · Clinton, ARN678JGHyannis Air Service Inc DBA · Hyannis, MAN678JSGolden Pegasus LLC · Hughson, CAN67909Hyannis Air Service Inc DBA · Hyannis, MAN67RZModular Aviation LLC · Saratoga Springs, UTN6813JHyannis Air Service Inc DBA · Hyannis, MAN6814RBbc414a LLC · Alton Bay, NHN6815TL A Flyers LLC · Monticello, ARN6817DGlasscock Charles W Jr · Elm Grove, LAN6818XBlue Skys Aero LLC · Vermilion, OHN681RCObsidian Air LLC · Pompano Beach, FLN6822EAir Force One LLC · Coral Springs, FLN6822UKw Aircraft LLC · Judson, TXN682JDWindward Air LLC · Orlando, FLN68379Express Carrier LLC · St Thomas, VIN68391Hyannis Air Service Inc DBA · Hyannis, MAN6839YRichland Aviation Inc · Sidney, MTN683TM007 Arkansas Aviation LLC · Jonesboro, ARN68752Hyannis Air Service Inc · Hyannis, MAN6875DHyannis Air Service Inc · Hyannis, MAN6879RHyannis Air Service Inc · Hyannis, MAN699TGTkg Aviation Inc · Port Orange, FLN700HBLucky7 Air LLC · Lenoir, NC
Back to AD 2005-12-13