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.
N47EZRinell Eric S · San Luis Obispo, CAN47FSDahl Duane A · Glasgow, MTN47GQMccoy Robert M · Barksdale, TXN47HJWhite Billy C · Baker, FLN47HSJames David R · Wayne, MIN47HYJoseph C Thomas · Lenoir, NCN47JGCorcoran Peter A · Fallbrook, CAN47JKKerr Jerry T · Mount Vernon, WAN47JLElliott David Robert · San Jose, CAN47JPBigger Val J · Las Cruces, NMN47JQJaquish William E · Tunkhannock, PAN47LMelugin Michael R · Manteo, NCN47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLN47LULetourneau University · Longview, TXN47MLWitt Jerry D III · Houston, TXN47NZFish Dwain E · Silver Springs, NVN47PGRandall Skye Sanjay · Lansdowne, PAN47PLGreer Wesley E · Woodstock, GAN47RGGossard Philip G · Stonington, MEN47RHWilson Alexander M · Inyokern, CAN47SSandlapper Aviation Of De Inc · Bennington, VTN47SDWampler William C · Canton, TXN47STFuhs Nicholas J · Advance, NCN47TDBeene Donald · Westfield, INN47TSStewart Terry · Anchorage, AKN47TWRiley Steven M · Bucyrus, KSN47VMCox Michael · Casper, WYN47WCFly Girls Aviation LLC · Saint Amant, LAN47WLSchettler Patrick J · Garnett, KSN47ZRZira 2x Alw LLC · College Place, WAFirst renewal noticeN48007White Andrew Kyle · San Diego, CAN4800LFlying Aces LLC · Scappoose, ORN4800MDunn Bernard P · Carson City, NVN4800VRegistered aircraftN4800ZGorzynski Dustin B · Great Falls, MTN4801GFrederick Aero Development Inc · Murrieta, CAN4801LWilliams Fire Apparatus Inc · Ashland, ALN4801ZButler Delbert C · Caldwell, IDN48024Aftcloud Inc · Ontario, CAN4802JSwaz Aviation LLC · Mesa, AZN4802LKrishna Vijay · Appleton, WIN4802TSmith Terry G · Kamuela, HIN4802ZHoffman James R · Bethel, AKN4803Molek Jon · Warren, OHN48033Franconi Michael J · Newington, CTN4803FNorman Howard A · Freeport, ILN4803GAarow Aircraft Leasing LLC · Mcminnville, ORN4803JWhite Jack D · Orangevale, CAN4803LJc And Co Menswear Inc · Tulsa, OKN4803ZBuffalo Flyers LLC · Buffalo, MO
Back to AD 90-04-06 R1