AD 2017-17-13
Registered aircraft · 883
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:2017-17-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:2017-17-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:2017-17-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:2017-17-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.
N708QCindago LLC · Rancho Cucamonga, CAN708QSRegistered aircraftN709QSBarnhart Interests Inc · Oklahoma City, OKN70CRWorld Wing Sales LLC · Pearland, TXN70RLBs Aviation Holdings II LLC · Englewood, CON710QSAir To Land LLC · Oklahoma City, OKN711HAHoyt Air Inc · Phoenix, AZN711QSCiena Corp · Oklahoma City, OKN712AQRrp Aviation LLC · Dover, DEN712BHProject Finance Inc · Ada, MIN712QSRegistered aircraftN712WBBlessey Aviation LLC · Big Sky, MTN713DHHigginbotham Management Co Inc · New Smyrna Beach, FLN713QSRegistered aircraftN714CGNisource Corporate Services Co · Columbus, OHN714FRgd Industries LLC · Logan, UTN715QSRegistered aircraftN-number assigned (import), not yet registeredN716QSRegistered aircraftN716WWWish Equipment LLC · Tallahassee, FLN717ASExecutive Airshare LLC · Lenexa, KSN717EPOssian Airways III Inc · Rochester, NYN717JJPita Magoo Holdings LLC · New York, NYN717QSRegistered aircraftN-number assigned (import), not yet registeredN718ASExecutive Airshare LLC · Lenexa, KSN718NBBlackhawk Equipment Leasing LLC · Jacksonville, FLN719ASExecutive Airshare LLC · Lenexa, KSN71FARegistered aircraftN722ASExecutive Airshare LLC · Lenexa, KSN723ASExecutive Airshare LLC · Overland Park, KSN723JMLoco Yenny LLC · Stuart, FLN724ASExecutive Airshare LLC · Overland Park, KSN724EHHolm Leasing LLC · Winter Park, FLN725NN3 Transportation LLC · Oakbrook Terrace, ILN725QSRegistered aircraftN726QSRegistered aircraftN727QSNetjets Sales Inc · Oklahoma City, OKN728QSRegistered aircraftN729JFJuliet Foxtrot LLC · Scott City, KSN729JMAir Bear Inc · Amarillo, TXN729QSRegistered aircraftN72GYBank Of Utah Trustee · Salt Lake City, UTN72JKKittle Aviation LLC · Indianapolis, INN72SMPnc Bank Na · Boise, IDN730ASBjaup LLC · Overland Park, KSN730JHRegistered aircraftN730QSRegistered aircraftN731QSRegistered aircraftN732ASCurran Aviation LLC · Mission Hills, KSN737QSRegistered aircraftN738ERegistered aircraft
Back to AD 2017-17-13