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.
N789BMMcanelly Gary Alan · Burnet, TXN789BNDanbom Jimmy D · Tavares, FLN789BRDelong David P · Kirkland, WAN789CEBond Brent L · Clearwater, KSN789DWFergus Falls Aviation LLC · Fergus Falls, MNN789EUnlimited Visibility LLC · Wilmington, DEN789FBHot Wings Aviation LLC · Fishers, INN789FGSolf William · Winnett, MTN789FWWalton Marketing Inc · Fort Worth, TXN789JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INN789JFCoordinated Turn LLC · Fort Worth, TXN789JMMathews John D · Fallbrook, CAN789JRMascheroni Andre R · Mccall, IDN789LHJones Aircraft Company LLC · Cross Plains, TNN789MAS D 789 Partners LLC · Batavia, ILN789MHHenderson Michael E · Edmonds, WAN789NDUnd Aerospace Foundation · Grand Forks, NDN789PZarski Rebecca Cross · Sharon Springs, NYN789PALong Jacob · Jupiter, FLN789RAMiller Melanie L · Spanaway, WAN789RLBlacktiger LLC · Wilmington, DEN789SVPaulukaitis Robert Adam · Hudson Oaks, TXN789UTradewinds Aero Inc · Traverse City, MIN789WEStoked Aero LLC · Camas, WAN789WTGabrys Ronald B · Wisconsin Rapids, WIN78AHCenturion Aviation LLC · Virginia Beach, VAN78AJHamlin Curits · North Pole, AKN78AKFreytag Ronald D · Stockton, CAN78ATSchrage Rodney L · Steamboat Springs, CON78BGKdrd Holdings LLC · Texas City, TXN78BYNorthwestern Michigan College · Traverse City, MIN78CWPotter Justin D · Eagle River, AKN78DFBurkett Robert S · Baytown, TXN78DJKing David V · Mars, PAN78DLBruns Luke · Flower Mound, TXN78DRWhitehead Michelle W · Centralia, WAN78DWNeu Lawrence R · San Antonio, TXN78EFFearnow Rolland E · Wabash, INN78FMFraker Gregory M · Plymouth, MIN78GCMh Aviation LLC · Foster City, CAN78GTBennett Wayne M Jr · Puyallup, WAN78HBValiair Lc Trustee · Casper, WYN78HYD A Lamont Public Adjusters LLC · Springtown, TXN78JDArtigas Gonzalo J · Cambridge, MAN78JHPlane Fun Inc Tr Trustee · Snellville, GAN78JMDye William M · Atlanta, GAN78JNMuseum Of Flight Foundation · Seattle, WAN78JRFocus Air LLC · Wilmington, DEN78KPYoungblood Dennis L · Crystal River, FLN78KVShore Dog Aviation LLC · Dover, DE
Back to AD 90-04-06 R1