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.
N853NBuffaloe Thomas N · Mancos, CON853NDUniversity Of North Dakota · Grand Forks, NDN853PChristian Daniel E · Winchester, VAN853RSOlson Helicopters LLC · Corpus Christi, TXN853RVPlumley James Christopher · Travelers Rest, SCN853SPPavilon Clemens J · Bolingbrook, ILN8540YCli Aerospace LLC · Appleton, WIN8541CHulsey Johnathan James · Wasilla, AKN8541EFlying Services Inc · Wilmington, DEN8542DScotts Helicopter Services Inc · Le Sueur, MNN8542YAviation Training Solutions LLC · Hilo, HIN8543DHuntwork Dayna · Boise, IDN8543EAce Aircraft Leasing Inc · Nazareth, PAN8544CNixon H M · Wayne, NJN8544DThames James W · Florence, ALN8545DFour-Five-Delta LLC · Mountainville, NYN8547Carlson Cory R · Trail, MNN8547ECarpenter Lionel Lee · South Fork, CON8548Collum Aviation LLC · Milton, FLN8548CMapes Peter B · Oscoda, MIN8549Koenig Steven T · Ostrander, OHN8549EDrageset Denvero · Isabel, SDN854ACKurchian Aram M · Sunland, CAN854AKAraki Satoshi · Hayward, CAN854CAJunie The Flying Dog LLC · Atlanta, GAN854DRDix Mark · Wray, CON854GRegistered aircraftN854GWCondair Flyers Inc · Latham, NYN854HCN854hc LLC · Watkinsville, GAN854KMSparrowhawk Aviation LLC · Hollister, CAN854NDAero Equities LLC · Ventura, CAN854PD139th Aeroclub LLC · Miami, FLN854RCKcs LLC · Dubuque, IAN854RVRoberts Thomas G · Seattle, WAN854TBBrown Thomas R · Gainesville, FLN8550CBig Sky Communication & Cable Inc · Billings, MTN8550DRiester Gary R · Navarre, FLN8551CRautiola Charles A · Rosemount, MNN8551VTall Timber Flying Service LLC · Kalispell, MTN8552DSvec Adolph Ralph · Marengo, ILN8552VBurkey Dale · Walnut, ILN8553CNext Flight Out Ltd · Wilmington, DEN8554DParks Alan J · Homer, AKN8554VPaulson Marshall R · Kenai, AKN8555Bank Of Utah Trustee · Salt Lake City, UTN8555YScharf Mark T · Rosamond, CAFirst renewal noticeN8556VParis Charles F · Pioneer, LAN8557DWells Michael D · Wilton, MEN8557HLloyd Davis Inc · Brackettville, TXN8557VBurton Michael B · Coweta, OK
Back to AD 90-04-06 R1