AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.
N408HBank Of Utah Trustee · Salt Lake City, UTN408MJSnowair LLC · Twin Bridges, MTN409FXFlexjet LLC · Cleveland, OHN409MRRegistered aircraftN40LGHilton Resorts Corp · Orlando, FLN410FXFlexjet LLC · Cleveland, OHN411FXBank Of Utah Trustee · Salt Lake City, UTN411STTsmc Leasing LLC · Baton Rouge, LAN412DLPnc Financial Services Group Inc · Pittsburgh, PAN413FXBank Of Utah Trustee · Salt Lake City, UTN413GGClyde Enterprises LLC · Greenville, NCN414FXFlexjet LLC · Cleveland, OHN414MFAirbill Inc · Portsmouth, NHN415FXFlexjet LLC · Cleveland, OHN415NGDt Re LLC · Silver Lake, KSN416FCitation X Leasing LLC · Liberty, NCN416FXFlexjet LLC · Cleveland, OHN417FXFlexjet LLC · Cleveland, OHN417HC417hc Holdings LLC · Johnstown, PAN418FXFlexjet LLC · Cleveland, OHN419FXFlexjet LLC · Cleveland, OHN41DP20010 Ventures LLC · Denver, CON41VDCommonwealth Aircraft Leasing Inc · Wilmington, DEN420MPChallenger 20420 LLC · Nashville, TNN421FXFlexjet LLC · Cleveland, OHN422CPPohlad Robert C · Minneapolis, MNN422FXFlexjet LLC · Cleveland, OHN422MPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN423FXFlexjet LLC · Cleveland, OHN423JGOwen Aviation LLC · San Diego, CAN424FXFlexjet LLC · Cleveland, OHN425MPBank Of Utah Trustee · Salt Lake City, UTN426FXFlexjet LLC · Cleveland, OHN426MPBank Of Utah Trustee · Salt Lake City, UTN427FXFlexjet LLC · Cleveland, OHN427MPBank Of Utah Trustee · Salt Lake City, UTN428FXFlexjet LLC · Cleveland, OHN429FXFlexjet LLC · Cleveland, OHN429RM429rm LLC · San Diego, CAN42GJJlj Equipment Leasing Corp · Hobe Sound, FLN430FXFlexjet LLC · Cleveland, OHN430WCElevation Aviation Services LLC · Aurora, ORN431FXFlexjet LLC · Cleveland, OHN432FXFlexjet LLC · Cleveland, OHN432MCMcm Air LLC · Midland, TXN433FXFlexjet LLC · Cleveland, OHN435FGN435fg LLC · Urbana, ILN435FXFlexjet LLC · Cleveland, OHN436FXFlexjet LLC · Cleveland, OHN437FXFlexjet LLC · Cleveland, OH
Back to AD 2018-04-13