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.
N43221Bednarz Joseph P · Hendersonville, TNN43224Piper Aviation LLC · Tierra Verde, FLN4322FAdk Xc Flyers LLC · Scotia, NYN4322GMid Atlantic Air Museum · Reading, PAN4322JDougherty Joseph P · Hughesville, PAN4322MVeal Jeffrey S · Sterling, AKN4322XManitowoc Flyers Corp · Manitowoc, WIN4322ZLee Gerald R · Glennallen, AKN43232N43232 LLC · Orange, TXN43234Level Up Aviation LLC · Newton, ALN4323HRucker Edward A · Longview, TXN4323QWausau Flying Service Inc · Wausau, WIN4323RMy Flight LLC · Cypress, TXN4323TBreitenstine Matthew · Dallas, TXN4323XRegistered aircraftN4323YRyer Michael · Salem, ORN4323ZDubious Adventures LLC · Big Lake, AKN43240O'Quinn Kayla M · Jesup, GAN43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAN43243Gomez Herbert · Holdenville, OKN43247Aircraft Guaranty Corp Trustee · Oklahoma City, OKN4324HTrott James E · Cathlamet, WAN4324JStaple K Aviation LLC · Queen Creek, AZN4324MMulligan William O · Valentine, NEN4324RShadle James A Jr · Gig Harbor, WAN4324ZBretts Spray Service Inc · Onida, SDFirst renewal noticeN43257P23 LLC · Edmond, OKN4325BWattum Joel W · Wasilla, AKN4325FIreland David · Eatonville, WAN4325JJpsc LLC · College Station, TXN4325QBeier Mark E · Sylvania, GAN4325RGaruda Aviation Inc · Miami, FLN4325TBledsoe Randell W · Springtown, TXN4325UMetro Aircraft Co · Bloomington, MNN4325VArcher Assoc LLC · Ashburn, VAN43263Healey Terrance P · Redding, CAN43265Logan Sonny · Lake Dallas, TXN43266Sky High Helicopters LLC · Camarillo, CAN43268Inter Global Aviation LLC · New Fairfield, CTN4326JHayes Barrett W · Siler City, NCN4326LN4326l LLC · Senoia, GAN4326NLikakis John M · Bennington, VTN4326QStar Fleet Aviation LLC · Bisbee, AZN4326ZSuchland Simon K · North Pole, AKN4327ACasten Scot R · Vernonia, ORN4327EPegasus Enterprises LLC · Overton, NVN4327QFackler Aviation Services LLC · Clearwater, FLN43287Carlucci Peter M · Pittstown, NJN43289Prickett Terry L · Albertville, ALN4328AHubert Matthew J · Fremont Center, NY
Back to AD 90-04-06 R1