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.
N77BLLesnett Robert Gage Trustee · Vida, ORN77BWWhitaker Eric · Detroit, TXN77CHTcb Management Inc · Chiefland, FLN77CVNaikelis Robert · Hampstead, NCN77DHBramon Bruce M · Sunrise Beach, MON77DWTop Flight Detail LLC · Middlebury, INN77EBBowles Alan B · Georgetown, TXN77EKRv 7 77 LLC · Port Saint Lucie, FLN77ERFrech Betty J Trustee · Columbia, MON77FLMeyer Adnrew J · Clear Lake, IAN77FSRoberts Eric · Grayslake, ILN77GParker Ray W · Nome, AKN77GATaliaferro John C · Abilene, TXN77GBSmith Kevin F · Sherman, TXN77GGCoben Craig S · Smithville, OHN77GHWagner Rickey J · Stacy, MNN77GLLange Cory J · Blaine, MNN77GMMartin Gustavo E · Cooper City, FLN77GRHubbard Benjamin L · Quogue, NYN77HLBarton Bruce N · White Hills, AZN77HXAppold Dave J · Bay City, MIN77JCMundwiler David Gary · Hemet, CAN77JGGoon Aviation LLC · Kalispell, MTN77JTDrewry James D · Dayton, TXN77JYPloeger William A · Melbourne, FLN77JZZimmerman James L · Arvada, CON77KFEischens Kolton S · Wasilla, AKN77KHHolcomb Ken C · San Diego, CAN77KSPerkins Carey Alan · Hesperia, CAN77KTRochna Stephen J · Fallon, NVN77LPrice Paul W · St George, UTN77LFWallace Dustin A · Vacaville, CAN77LHRegistration Pending · Cape Coral, FLRegistration pending, canceledN77PLVrooman Lawrence M · Winterville, NCN77PSClelland Belinda S Executor · Tucson, AZN77RCN77rc LLC · Wilmington, DEN77SHaagenson Jeffrey · Portland, ORN77SAScs Aviation Inc · Wilmington, DEN77SGTimestone Corp · Calexico, CAN77SLSanders Wiley C Jr · Troy, ALN77STJb Ag Service LLC · Colstrip, MTN77SXGibson Jonathan T · New Iberia, LAN77TBGlass Ralph D · Elgin, TXN77TCSky King Aviation LLC · Helena, MTN77WDVoliva Larry E · Denton, TXN77WESteven Paul Joyner · Austin, TXN77WGBuergel Sandra J · East Aurora, NYN77WKHartman Troy E · Temecula, CAN77XAJohnson Jason A · Seal Beach, CAN77XXKenan Aviation LLC · Yuma, AZ
Back to AD 90-04-06 R1