Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N613RFB R S Leasing Inc · Wilmington, DEBuilt 1983 · S/N LJ-1068 N613RLAtc Aero LLC · Kingman, AZBuilt 2013 · S/N 208B5016 N613TAWild Blue Aviation LLC · Wilmington, DEBuilt 1997 · S/N BB-1581 N613TREquipment King LLC · Waco, TXBuilt 1998 · S/N FL-230 N6146MBluewater Na LLC · San Diego, CABuilt 1981 · S/N E-1959 N6147UStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2010 · S/N FL-697 N6147YStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2096 N6148XHrg3 LLC · Yuma, AZS/N E-3548 N614ARTwin Otter International Ltd · Las Vegas, NVBuilt 1979 · S/N 614 N614ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30343 N614CPInternational Aircraft Marketing & Sales LLC · Sarasota, FLBuilt 1978 · S/N 551-0027 N614CWBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N FL-84 N614GGTannelle Ltd · Manassas, VABuilt 2003 · S/N 525-0510 N614JKUniversal Pacific Investment Corp · Portland, ORBuilt 1984 · S/N S550-0018 N614MMN9454h Inc · Wilmington, DEBuilt 1980 · S/N E-1735 N614TMHallman David M Jr · Erie, PABuilt 1974 · S/N E-567 N6150CNantucket Aviation LLC · Plymouth, MNBuilt 1981 · S/N E-1960 N6159VStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2106 N615AJPaloma Air LLC · Santa Maria, CABuilt 1993 · S/N 560-0231 N615ARTwin Otter International Ltd · Las Vegas, NVBuilt 1979 · S/N 615 N615ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30344 N615HRAjv Aviation Holdings LLC · Venice, FLBuilt 1995 · S/N 560-0309 N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266 N615SCSvp LLC · Missoula, MTS/N 26100 N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895 N6163RSai Flight Services Inc · Greer, SCBuilt 1981 · S/N E-1967 N61698Wildfire Aviation LLC · Wilmington, DES/N LJ-1698 N616BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5797 N616CFTfo Aircraft II LLC · West Chester, PABuilt 2022 · S/N 525-1112 N616JARegistered aircraftBuilt 1985 · S/N E-2285 N616MRRioco Corp · Mcallen, TXBuilt 2016 · S/N FL-1060 N616NEWarmont Company · Midland, TXBuilt 2008 · S/N 560-0777 N616PRRubicon Investments Corp · Salem, ORBuilt 1999 · S/N 525-0326 N616RPCapling Aviation LLC · Labelle, FLBuilt 1989 · S/N FA-181 N616TGYucaipa Aviation Inc · Alvarado, TXBuilt 1986 · S/N S550-0119 N616WGForza Wings LLC · Laredo, TXBuilt 1985 · S/N 258030 N61726Davis Aviation Inc DBA · Brandon, MSS/N FL-626 N61729Marine Connection Leasing LLC · Vero Beach, FLBuilt 2009 · S/N 208B2135 N61788Zimin Transportation LLC · South Naknek, AKS/N FL-648 N617ABAb Squared LLC · Deephaven, MNBuilt 1996 · S/N 525-0140 N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897 N617MMCal-Ore Life Flight LLC · Brookings, ORBuilt 2000 · S/N LJ-1587 N617PTSmart Motion Aviation LLC · Frisco, TXBuilt 1979 · S/N TH-1043 N617RMMontana Sky Assets LLC · Helena, MTS/N LJ-1095 N617STSartec Corp · Pensacola, FLBuilt 2004 · S/N 208B1044 N617USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21121 N618United States Department Of Interior · Boise, IDBuilt 1990 · S/N BB-1378 N6181UAndrew Investment Company LLC · Atoka, OKBuilt 1981 · S/N E-1970 N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484 N6182PStorch Mark Gerald Trustee · Ridgecrest, CABuilt 2005 · S/N E-3582

Back to AD 2006-16-18 R1