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.
N4196HBurnett John A · Wadsworth, ILN4196PHarmon Aviation LLC · Exeter, NHN41973Legacy Aviation LLC · Murfreesboro, TNN41977Augusti Group Enterprises Inc · Clayton, NCN41978Henderson Jason E · Corona, CAN4197YAgnew Michael D · Pardeeville, WIN4197ZBurns Barry D · Amarillo, TXN41980Warren Donald E · Pine Bluff, ARN41983Brotherman LLC · Hereford, TXN41985Aerospace Systems And Training LLC · Orange City, FLN41988Sky High Investments LLC · Greenwood, INN4198BAero Flight Flying Club · Minneapolis, MNN4198FRal Aviation LLC · Trumbull, CTN4198RTaf Aerial Services LLC · Beeville, TXN4198YGallo Michael R · High Falls, NYN4198ZMcfarlane Bradley J · Port Alsworth, AKN41992Stein Anthony J · Locust Grove, GAN41995Columbus State Community College · Columbus, OHFirst renewal noticeN41997Caae Leasing LLC · Lake Zurich, ILN4199AKiser Richard K · Mount Solon, VAN4199HN4199h Club Llp · Oshkosh, WIN4199JHallenbeck Jesse · Bellingham, WAN4199ZSymanowski Kevin · Reeder, NDN419ACSimmons Scott · Anchorage, AKN419AKSpats Aviation LLC · Toledo, OHN419ALTomahawk Aero Services LLC · Bellingham, WAN419DTurner Spencer A · Modesto, CAN419DMNote Clayton R · Eagle Point, ORN419FKlenoski Brian D · Fulton, MIN419FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN419GCareer Pilot Training LLC · Wilmington, DEN419GCRiley Bradlee A · Archdale, NCN419JNWheeler Kelly · Columbia Falls, MTN419LKSluka Christopher · San Diego, CAN419MGAnderson Todd · Bondurant, IAN419PASkywest Leasing Inc · St George, UTN419RStruthers Robert J · Geneva, ILN419SGilpin Nathan L · Cornelia, GAN419SAStephens Kristi J · Bellingham, WAN419SFTotal Flight Aircraft Leasing LLC · Apex, NCN419TEEp Enterprises Inc · San Juan, PRN419WAnn Arbor Flyers Inc · Ann Arbor, MIN419WPHole Jeffrey Wayne · Stockton, CAN419YBBlum Bradley R · Waukesha, WIN41ACPitts Flying Club Of Stoughton · Stoughton, WIN41AGSkyline Agrinautics Inc · Osage, IAN41AHHarding Kenneth H · Columbus, OHN41AMStephens Calvin · Adrian, GAN41APRising Wings Aviation Inc · Casper, WYN41AWWalker James A · Birmingham, AL
Back to AD 90-04-06 R1