AD 2023-06-13
Registered aircraft · 138
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:2023-06-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:2023-06-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:2023-06-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:2023-06-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.
N2BWBank Of Utah Trustee · Salt Lake City, UTN302AGWilmington Trust Company Trustee · Wilmington, DEN328LMMd Jacaranda LLC · Wilmington, DEN365DGLhm Man Eqp LLC · Sandy, UTN365GCGulf Coast Capital Holdings LLC · Aventura, FLN369WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN36BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN372ETTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN378TPEtpc Aviation LLC · Atlanta, GAN392MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN393BXIac Falcon Holdings III LLC · New York, NYN3TSXrs LLC · La Jolla, CAN40NWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN40WRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN41127Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN421SZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44440Registered aircraftN444WTWhisky Tango LLC · North Sioux City, SDN470BReina Capital LLC · Miami, FLN48ENWilmington Trust Co Trustee · Wilmington, DEN512GLRtw Goco LLC · New York, NYN5184Registered aircraftN520EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555MZGii Aircraft Trust · Wilmington, DEN55UNRegistered aircraftN-number assigned (import), not yet registeredN577KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN580KCRegistered aircraftN588CHBank Of Utah Trustee · Salt Lake City, UTN625SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN62LVAmb Group LLC · Atlanta, GAN63RPMirasol Sky LLC · Dallas, TXN646AKBank Of Utah Trustee · Salt Lake City, UTN670BBCsc Delaware Trust Co Trustee · Wilmington, DEN675BBCsc Delaware Trust Co Trustee · Wilmington, DEN680BAFks Aviation LLC · Richardson, TXN689BCRegistered aircraftN699FBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6LBN6lb LLC · Dover, DEN70EWEwa Holdings LLC · Teterboro, NJN71100Wilmington Trust Co Trustee · Wilmington, DEN725LBRegistered aircraftN729KFKw Flight LLC · Bozeman, MTN729VSRegistered aircraftN7500G7500 Msn 70023 Leasing LLC · Pompano Beach, FLN7508Bank Of Utah Trustee · Salt Lake City, UTN7509Bank Of Utah Trustee · Salt Lake City, UTN750AGTvpx Trust Co LLC Trustee · North Salt Lake, UTN750KDWilmington Trust Co Trustee · Wilmington, DEN750PBGlobal Support LLC · Salt Lake City, UTN750SFHamilton Aviation Inc · Portland, OR
Back to AD 2023-06-13