AD 2017-08-01
Registered aircraft · 572
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-08-01')
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-08-01')
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-08-01') 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-08-01') 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.
N61318Wilmington Trust Co Trustee · Wilmington, DEN613AQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN613BRRegistered aircraftN616AFAmeriprise Financial Inc · Oxford, CTN616CAPioneer Hi-Bred International Inc · Wilmington, DEN616RKBank Of Utah Trustee · Salt Lake City, UTN617EAMeridien Aircraft Holdings LLC · Greenwich, CTN619GVTrans-Exec Air Service Inc · Van Nuys, CAN620JHBank Of Utah Trustee · Salt Lake City, UTN621MDBide A Wee LLC · Newark, DEN623TAL3 Harris Technologies Inc · Waco, TXN625GNPaper Airplanes 3 LLC · Scottsdale, AZN626JEMmap III LLC · Houston, TXN626RAMavir LLC · Albany, NYN62FFPsalm 52:8 LLC · Dover, DEN631VRDoheny Leasing Inc · Culver City, CAN640WBank Of Utah Trustee · Salt Lake City, UTN641GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN642GAGulfstream Aerospace Corp · Savannah, GAN645CCL3harris Technologies Flight Capital LLC · Greenville, TXN645EARegistered aircraftN-number assigned (import), not yet registeredN645LHL3harris Technologies Flight Capital LLC · Greenville, TXN65CCNbi Holdings LLC · New Bremen, OHN65KLRegency Aviation LLC · Edgewater, MDN660HH94924 LLC · Medford, ORN665JJUmb Bank Na Trustee · Salt Lake City, UTN66CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN670RRTvpx Trust Co LLC · North Salt Lake, UTN671LEGreen Sky Aviation LLC · Jupiter, FLN677FNational Science Foundation · Alexandria, VAN688CBFrc Holding Inc V · Dover, DEN699KRBank Of Utah Trustee · Salt Lake City, UTN69CKCd 321 LLC · Austin, TXN6JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6PCMountain Aviation Leasing LLC · Park City, UTN700HAWilmington Trust Co Trustee · Wilmington, DEN702QVNaqvi Law LLC · Las Vegas, NVN703FSFlo-Sun Aircraft Inc · West Palm Beach, FLN703RKEmergence Southwest LLC · Jacksonville, FLN708JHUnited States Government · Washington, DCFirst renewal noticeN709AABank Of Utah Trustee · Salt Lake City, UTN71111Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN711EGG550 N711 LLC · Newport Beach, CAN712LWWanderweg Holdings LLC · Salt Lake City, UTN716ASAs Aviation Holdings LLC · Wilmington, DEN716GCGreat Clips Inc · Minneapolis, MNN718JJJj Acquistions 681 LLC · Secaucus, NJN718MCRadical Ventures LLC · Dallas, TXN718PMConfectionery Advantage LLC · Park Ridge, NJN721AZSz Aviation LLC · Miami, FL
Back to AD 2017-08-01