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.

N321BZJakes Air Service LLC · Holt, FLBuilt 1999 · S/N 22968 N321CKFairwinds Aviation LLC · Goldsboro, NCBuilt 2004 · S/N 40.414 N321DDoyle Charles J · Sequim, WABuilt 1974 · S/N AA1B0321 N321DFFranklin David A · Sealy, TXBuilt 2001 · S/N 570E N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321EFRengel Richard J · Tustin, CAS/N 1900 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321FSUtah State University · Logan, UTBuilt 2004 · S/N 40.384 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321JECapital Affairs West LLC · Helena, MTBuilt 2004 · S/N 40.374 N321KJFly-By LLC · Cope, COBuilt 2022 · S/N 12190081 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321LMStarkey Mike · Dayton, NVBuilt 2021 · S/N 12180029 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321MLSalerno Lawrence B · St Charles, ILBuilt 1991 · S/N 1042 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321PBWickersham Grover T Trustee · Gardnerville, NVBuilt 1963 · S/N 515 N321PFRrsf LLC · Pleasant Grove, UTBuilt 2004 · S/N 40.375 N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1 N321RCHitchen Robin J · Bernardsville, NJBuilt 2013 · S/N 90217 N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77 N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189 N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372 N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321TBradshaw & Company Insurors · Dyersburg, TNBuilt 1953 · S/N 18-2435 N321TAAldag Thomas D · Wichita, KSBuilt 2020 · S/N 83171 N321TDDeakyne David J · Wallingford, PABuilt 1992 · S/N DEAKYNE 0001 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665 N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533 N321VESullivan Mike D · Braddyville, IABuilt 1995 · S/N DMO243 N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327 N321YZStroh Michael · Killdeer, NDS/N 28-7505039 N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036 N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094 N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097 N32207Petersen David A · Soldotna, AKBuilt 1947 · S/N 7856 N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037 N32210Steiner Hans L · Exeter, CABuilt 1954 · S/N 7859 N32223Boehm William Dean · Baldwin, ILS/N 28-7515101 N32225Tranby Todd · Minot, NDS/N 7874

Back to AD 90-04-06 R1