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.
N83480Kloker Daniel E · Owasso, OKN8348LPrice William B · Lamar, SCN8348MWings Over Texas Holdings LLC · Denton, TXN8348RMorris Jeff L · Radcliffe, IAN8348WAmerican Equipment Sales Inc · Lawrence, KSN8348YNelson Brian · Wakefield, NEN83494Knutson Wayne R · Tioga, NDN83497Popov Chris · Hope, IDN8349EArment C Randall · Valentine, NEN8349JCherry Michael A · Winchester, ILN8349TStefan Terrence J · Dodge City, KSN8349WGrayhawk Flight Training LLC · Lucas, TXN834ATDot Aviation LLC · Wilmington, DEN834DVVeith Donald C · Cattaraugus, NYN834GTIlmberger Stephen R · Sisters, ORN834KTChambers Garland M · Roanoke, VAN834NDUnd Aerospace Foundation · Grand Forks, NDN834SHSmith Helicopters Inc · Cotulla, TXN834TFAir Fleet Holdings LLC · Missoula, MTN834TTFerreira Mario · New Bedford, MAN834WVVarnedoe Wyman E · Monument, CON8350MVortex Leasing LLC · Racine, WIN8350RPerinoni Edward Jr · Novato, CAN8350VMertz Rachel A · New Ulm, MNFirst renewal noticeN8350WJr Aviation Holdings LLC · Newark, DEN8351Zeller Francis J · Rosamond, CAN83516Airo LLC · Belmont, WIN8351LPlane Junkies LLC · Dover, DEN8351WQuality Aero LLC · East Aurora, NYN83524Curtis Blake B · Clovis, NMN8352DScarlet Wings LLC · Brunswick, OHN8352LFielding David · Scarborough, MEN8352RQuantum Aviation LLC · Wauna, WAN8352TFlight Inc · Lakewood, CON8352WLebanon Flying Club · Lebanon, MON8352YSkylandsair LLC · Port Orange, FLN83539Silbersiepe Thomas E · Catlett, VAN8353COstwinkle Jeffrey J · Justin, TXN8353DKauffman Land & Development LLC · Fort Lupton, CON8353MCrosswind Leasing LLC · Prescott, AZN8353RSchrandt Mark L · Shoreview, MNN8353VN8353v LLC · Monroe, LAN8353WN8353w Flyers LLC · North Las Vegas, NVN8353YSoutheast Leasing LLC · Delray Beach, FLN83540Red Tail Scholarship Foundation · Tuskegee, ALN83545Mayeur Clint · Wasilla, AKN83549Giacometto John T · Broadus, MTN8354CTayab Farooq · Allen, TXN8354JOld Buzzard Aviation Inc · Middleburg, FLN8354LEast Texas Imperial Petroleum LLC · Flint, TX
Back to AD 90-04-06 R1