AD 90-04-06 R1
Registered aircraft · 68,375
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.
N32364Buffalo Ridge Aviation LLC · White, SDN32366Neff T J · Novato, CAN32367Martin Stephen · Bonney Lake, WAN32369Avia Flight Academy LLC · Stratford, CTN3236BSoderman David W · Gilby, NDN3236PFalcon Air LLC · Anchorage, AKN32372Polestar Inc · Columbus, OHN32374Komar Ana · Maspeth, NYN32375Mersereau Austen D · Anchorage, AKN32376Delaware State University · Dover, DEN32378Sanders David D · Alvin, TXN32379Erkert Jason A · Phoenix, AZN3237NLee Leo Lea Young · Pasadena, CAN32384Metz Justin · Scottsdale, AZN32386Rice Craig W · Walnut Creek, CAN32387Mclelland Brenda M · Springfield, MON3238AHawley Timothy J · Ashland, OHN3238ESwiss Jack S · Anchorage, AKN3238FKercheval Todd R · Georgetown, TXN3238MNord Margie N Trustee · Cantwell, AKN3238QAttitude And Configuration Indicator LLC · Bedford, TXN3238ZZulu Flight LLC · Washougal, WAN32390Gruendling Kurt · Shelburne, VTN32392Devrnja Aero LLC · Knoxville, TNN32393Mcnamee James R · Cocoa, FLN32397Tanya Austin L · Newburgh, NYN3239ELeaf Air LLC · Queensbury, NYN3239ZRoach Aviation LLC · Longview, TXN323AGalloway Lyle R · Ashton, IDN323BETracy Brian R · Georgetown, OHN323BGElectric Cowboy Aviation LLC · Okeechobee, FLN323BTOlson Bryce T · Fertile, MNN323CAChatman Ira D · Mountain Home, ARN323DProfessional Training Aircraft LLC · Wilmington, DEN323DHKleinsmith Stacee F · Eagle River, AKN323EHBates Joseph E · Providence, UTN323ESAdams Samuel M · Anna, TXN323FSFredericks Hall Aviation LLC · Mineral, VAN323GSSpengler Gregg R · Potsdam, NYN323HJetzer Michael · Sherrills Ford, NCN323HGGulf State Aviation LLC · Tomball, TXN323HKTaylor Aviation Inc · Montgomery, NYN323JMDubbert Roger D · Mexico, MON323JPWyatt Equipment Inc · Basin, WYN323JSCabe Joseph L Jr · San Antonio, TXN323MGRstv Inc · Dubuque, IAN323NDUniversity Of North Dakota · Grand Forks, NDN323PRSport Flying USA Services LLC · Lititz, PAN323RDexter Fred H · Live Oak, FLN323SAPfister Patrick · Pinedale, WY
Back to AD 90-04-06 R1