Registered aircraft · 68,375

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

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

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.

N33545Beck Brady P · Nixon, TXBuilt 1975 · S/N 28-7525206 N3354XVirginia Aircraft Rentals LLC · Broadway, VABuilt 1966 · S/N 1079 N3354ZJohnson Charles D · Benson, AZBuilt 1960 · S/N 22-7294 N33550Nutmeg Flying Club · Stratford, CTBuilt 1975 · S/N 28-7505157 N3355BGar Aviation Inc · Lexington, ORBuilt 1954 · S/N 18-3308 N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515 N3355ZSmp Wind River LLC · Thermopolis, WYBuilt 2005 · S/N 22576 N33560Sherron Jim Kemp IV · Raleigh, NCS/N 28-7525207 N33562Aiken Flyers LLC · Aiken, SCS/N 28-7525208 N33563Cape Fear Aviation Services LLC · Fayetteville, NCBuilt 1975 · S/N 28-7515346 N33565James Harris · Helotes, TXBuilt 1975 · S/N 28-7505158 N33566Roebke Karen L Trustee · Gilbert, AZBuilt 1975 · S/N 28R-7535161 N33567R Merritt Investments Inc · Jonesville, MIBuilt 1975 · S/N 28R-7535162 N3356DShapiro David M · Homer, AKBuilt 1994 · S/N 2461 N3356MH E P Flying Club Corp · Wyoming, MNBuilt 1947 · S/N 12-2184 N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656 N33575Nationwide Aviation LLC · Hudson Oaks, TXS/N 28-7515347 N3357KNewman Steve M · Portland, ORS/N 1350 N3357MSmith James R · Toney, ALBuilt 1947 · S/N 12-2049 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297 N33595N33595 Cherokee LLC · Austin, TXBuilt 1975 · S/N 28-7525211 N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165 N3359BWoodman Dwight C · Windham, MES/N 18-3313 N3359MWarren Wesley L · Coeur D Alene, IDBuilt 1947 · S/N 12-2216 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367 N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085 N335BWThorp T-18 Ri LLC · Foster, RIFirst renewal noticeBuilt 1995 · S/N 720 N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372 N335ERunia Allan D Trustee · Gold Hill, ORBuilt 1992 · S/N 246 N335FDRoy Martin P · Chehalis, WABuilt 1989 · S/N 335 N335HCOtis Stephen H · Mcalester, OKBuilt 2006 · S/N 022 N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N335PABorek Thomas J · Homestead, FLBuilt 1979 · S/N 18-7909158 N335RKGallant David A · Hartsel, COBuilt 2013 · S/N 001 N335RLWeeks James S · Boynton Beach, FLBuilt 2002 · S/N 23254 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N335RVCroce Matthew A · Palo Alto, CABuilt 2008 · S/N 80335 N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495 N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464 N335WMMilbauer Wayne N · Fuquay Varina, NCBuilt 2024 · S/N 112-215/216-1088 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N3360PThomas Lyndon J · Wasilla, AKBuilt 1950 · S/N 18-391 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3361ANimmick Robert A · Three Forks, MTFirst renewal noticeS/N 20-1067

Back to AD 90-04-06 R1