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.
N5089GFlywell Aviation LLC · Bowling Green, KYN5089JWentzel Ron · Steamboat Springs, CON5089PBroburg Gregory William · Minneapolis, MNN5089RHigh Wing Air Services LLC · Merritt Island, FLN5089STye Richard Ray · Silverado, CAN5089XYarger Pete A · Hamilton, INN508AFAmerican Air Academy Inc · Merritt Island, FLN508BDIron Wings Aviation LLC · Ralph, MIN508GLCirone James · Pampa, TXN508MARms Beach Sierra LLC · Brownsville, TXN508RFFugate Richard Dee · Rochester, MNN508TBlackburn D S · Yukon, OKN508THFowler David P · Freeport, MEN508VStahl Victor A · Houston, TXN508VKShuwayhat Khalid Numan Trustee · Phoenix, AZN508XCHirst Jeremy · Solana Beach, CAN50906Aitken & Wilson Aviation LLC · Leesburg, VAN5090EMelbourne Flight Training LLC · Melbourne, FLN5090MAri Ben Aviator Inc · Fort Pierce, FLN5090QTakai Hiroyasu · San Jose, CAN5090SSturm Neal M · Randolph, NJN5090TWoodcox Edmund A · West Monroe, NYN5090WJaybird Aviation LLC · San Antonio, TXN5090XOwen Suzanne L · Eagle Point, ORN5091717 Leasing LLC · Englewood, CON5091EAmerican Asset Leasing LLC · Aurora, ORN5091PSpicuzza Robert A · Waterford, MIN5091WRegistration Pending · Anchorage, AKRegistration pendingN5091XMorois Jake D · Green Bay, WIN50924Robinson Mark V · Vacaville, CAN50926Registered aircraftN5092EKaye Russell G · New Fairfield, CTN5092MZavalney Steven Michael · Canyon, TXN5092TZigo Daniel N · Madill, OKN5092XCurcio Joseph A Jr · Granite Bay, CAN50935Civil Air Patrol Inc · Maxwell Afb, ALN5093EBohmer Carla M · Tulsa, OKN5093KL A M Capital Management LLC · Sheridan, WYN5093PAir Chutney LLC · Waynesboro, VAN5093QRiya Aviation LLC · Tracy, CAN5093RSkyhawks Inc · Montoursville, PAN5093SPerez Matthew C · Indianapolis, INN5093TTaylor Allen S · Oak Harbor, WAN5093ZSelby Gerald A · Sand Springs, OKN50941Labrucherie Peter E · El Centro, CAN50944Munoz Jacqueline T · Huntsville, ALN50947Bend Aircraft Mechanics LLC · Bend, ORN5094BSmith Glenn · Orange Park, FLN5094LGorge Winds Aviation Inc · Fairview, ORN5094RHigh View Air LLC · Driftwood, TX
Back to AD 90-04-06 R1