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.
N80772Payne Michael S · Sequim, WAN80773Boyl Traci L · Ukiah, CAN80774Dugger Aviation LLC · Merritt Island, FLN80775Sierra Bravo LLC · Littleton, CON80779Stein William R · Aptos, CAN8077CDavis Kern M · Saint Petersburg, FLN8077ESws Aviation Services Inc · Titusville, FLN8077GPhillips Stuart · La Conner, WAN8077H8077h LLC · Southington, CTN8077NRodgers Wesley T · Enterprise, ALN8077QWakefield Robert · Toccoa, GAN8077RIscovich Mario S · Thousand Oaks, CAN8077ULeavitt Erin G · Lewiston, IDN8077WN8077w Inc · Bloomfield Hills, MIN8078Tkg Aviation LLC · Denver, CON80781P D H S Aerial Photography Inc · Spicewood, TXN80784Stamm David A · Lake Almanor, CAN80785Campbell Air LLC · Angola, INN80788Bell Aa Flying Club Inc · Mechanicsburg, PAN8078DStevenson William E · Sutton, AKN8078G615dm LLC · Hazel Green, ALN8078QRegistered aircraftN8078RKhozam George · Murrieta, CAN8078ZL & A Bennett Second Family Lp · Renton, WAN80790Wingsleasing LLC · Wichita, KSN80796Supina Mickey A · Prescott, AZN80797Neitz Frank · Bethel, AKN80798Thomas Dean Properties LLC · O Fallon, MON8079CFlying D Farm Inc · Kerhonkson, NYN8079WFox Michael · Winfield, KSN8079YKaszuba Peter M · Bradenton, FLN807APTexas South Wind Aviation LLC · Kenedy, TXN807DAMays Gloriaj · College Station, TXN807DBAnderson Richard D · Trophy Club, TXN807DLLove Mike · Lufkin, TXN807EHLindsey Daniel Rey · Clovis, NMN807EJBaldmans Aircraft Services LLC · Wilmington, DEN807HDTubbs Jerry M · Manns Harbor, NCN807RVMayerhofer Andrew M · Sugar Grove, ILN807SPCawthon James B · Chelsea, ALN807TFAir Fleet Holdings LLC · Addison, TXN807WMGriswold George B III · Cedar Point, NCN807WTWindigo Transportation Inc · Waterloo, IAN80800West Bend Air Inc · West Bend, WIN80803Bradley Charles S · East Bethel, MNN80807Wings Over Texas Holdings LLC · Denton, TXN8080AChapel Hill Flying Club Inc DBA · Sanford, NCN8080UMaas Justin J · Columbus, INN8080YEmerald City Aircraft Leasing Inc · Port Orchard, WAN80810White Hawk Aviation Inc · Brandy Station, VA
Back to AD 90-04-06 R1