Registered aircraft · 68,369

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.

N169BDFun Flying LLC · Riverwoods, ILS/N 1706 N169BFBurklund Joel · Minneapolis, MNBuilt 1995 · S/N 1392 N169BRReyna Benjamin M · Bulverde, TXBuilt 2005 · S/N 2019 N169BTAtkison Keith · Centre, ALBuilt 1966 · S/N 28-3776 N169CMOsborne Dennis M · East Petersburg, PABuilt 1979 · S/N 32843 N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150 N169DDFlughafen Skyport Ltd · Wilmington, DEBuilt 2001 · S/N 455-2001 N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515 N169EZMallory Jessica Lynn · Anchorage, AKBuilt 1976 · S/N 927-76 N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047 N169GACut And Snip Flyers LLC · South Weber, UTBuilt 1993 · S/N 2108 N169GSScott Gary L · Kings Beach, CABuilt 2022 · S/N 1165169 N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693 N169HRStrategic Aircraft Management LLC · Fairbanks, AKBuilt 2004 · S/N 0001 N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262 N169JRHull Terri L · Weirsdale, FLBuilt 2010 · S/N 24081 N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375 N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234 N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449 N169MJPlane Metrics LLC · Fort Worth, TXBuilt 2011 · S/N 80501 N169RVFoster John O Jr · Hillsboro, ORBuilt 2013 · S/N 90574 N169SHEaa Aviation Foundation Inc · Oshkosh, WIS/N 0169 N169TRParker Timothy N · Socorro, NMS/N 169 N169TSKestrelx LLC · Lake Mary, FLS/N 1694 N169WHNoble John E · New Kent, VABuilt 2004 · S/N JC10 N16AEKessler Samuel A · Cave Creek, AZBuilt 1984 · S/N 1470 N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057 N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693 N16AUTulsa Air And Space Museum Inc · Tulsa, OKS/N 002 N16AVRanzenbach Edward · Albemarle, NCBuilt 2013 · S/N 2 N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456 N16BWSaul Robert D III · Florence, COS/N BW 2-1 N16CBBoecher Carl A · Morrison, COBuilt 2018 · S/N 72745 N16CRHoughton Thomas J · Preston, CTBuilt 1974 · S/N AA5-0679 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N16DMBordonaro Dominic L · Stratford, CTBuilt 1962 · S/N 23-1157 N16ECSchnell Michael D · New Bremen, OHBuilt 1965 · S/N 28-2683 N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189 N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441 N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927 N16ERNeale Dorland F · Florence, ORBuilt 1977 · S/N 240 N16FWSwain Kenneth C · Harvard, ILS/N 28 N16GAGuidance Helicopters Inc · Prescott, AZBuilt 2001 · S/N 3211 N16GLDuncan David · Colorado Springs, COS/N 0772 N16HCPrivate Consulting Partners LLC · Boynton Beach, FLBuilt 2022 · S/N 3399 N16HFUniversal Aviators Academy Inc · El Monte, CABuilt 1988 · S/N 0778 N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675 N16HWKelley John E · Bartlett, TNBuilt 2001 · S/N 1 N16JBRegistration Pending · Pawleys Island, SCRegistration pendingS/N 151 N16JLBilyeu James L · Mckinney, TXBuilt 1999 · S/N 001

Back to AD 90-04-06 R1