AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N5094SBoraam Aviation Inc · Prospect Heights, ILN5094TKrass Roman · West Hills, CAN5094ZDugan Garry P · Manvel, NDN5095PGyrfalcon Air Holdings LLC · Boise, IDN5095RTraining Planes LLC · Tampa, FLN5095TColter Duane E · Plainfield, INN5095WBailey Bruce B · Dublin, VAN50961Flight Skills LLC · Raleigh, NCN50967Sellers Raymond L · Trussville, ALN5096DSchrader Thomas R · Anchorage, AKN5096GRiya Aviation LLC · Tracy, CAN5096HMyhre Norman G · Hixton, WIN5096LPea-Wayman Flight LLC · Daytona Beach, FLN5096TRichards Lyle D · Riley, KSN5096XKanooth Michael L · Washougal, WAN5097EBenedikt Craig A · Clayton, GAN5097RPlymouth Flying Club Inc · Plymouth, NCN5097VCamm Air · Spencer, IAN5097ZMoore Jay G · Billings, MTN50987Berg James O · Dunseith, NDN50988Propability One LLC · Daytona Beach, FLN5098RWilliams Austin T · Sheridan, INN5098SBadenhope John R · Greeneville, TNN5098VHarvestowne Aviation LLC · Saint Charles, MON5098XFontenot Reginald J · Church Point, LAN5098ZHanlon Ronald J · Seattle, WAN50996Burke John E · Spring, TXN5099CRinker Robert W Jr · Seattle, WAN5099KSaari Michael · Sycamore, ILN5099MBufo David · Los Osos, CAN5099RFly High Aircraft Sales LLC · Ocilla, GAN5099TClark Darril W · Scappoose, ORN5099VNew Horizon Aviation Inc · Warwick, RIN5099XBailey Carlton D · Huntington, WVN5099ZKaufold E Richard · Ridge, NYN509ANecochea Juan · Cedar Ridge, CAN509AFAmeriflyers Of Texas Inc · Addison, TXN509AMAmerican Asset Leasing LLC · Aurora, ORN509ATPollard Weldon Luke · Ardmore, OKN509CBHouseman Jeffery D · Millersville, MON509DBMaycroft David E · Cary, ILN509MROchoa Manuel · Medical Lake, WAN509MSAhmed Asif · Canoga Park, CAN509PCRich Lucas Aircraft Sales LLC · Lincoln Park, NJN509RWRegistered aircraftN509SMCompton Stephen · Kennewick, WAN509SPScandinavian Aviation Academy Inc · El Cajon, CAN509SWMeise Weston · Moses Lake, WAN509TCPattys Plane LLC · Tampa, FLN50AAOgonowski Kristine Staffeldt · Wasilla, AK
Back to AD 90-04-06 R1