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.

N6108STorres Jose C · Santa Clarita, CABuilt 1982 · S/N E-1946 N610BABering Air Inc · Nome, AKS/N 208B5314 N610BDReiter Kenneth Lee · Plano, TXBuilt 1977 · S/N 5010026 N610CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 525-1066 N610GGN610gg LLC · Pompano Beach, FLBuilt 1980 · S/N 501-0170 N610LAT & T Capital Inc · Bangor, MEBuilt 2004 · S/N 208B1060 N610RSRsc 1972 LLC · Valdosta, GAFirst renewal noticeBuilt 2002 · S/N 560-0610 N610TANorth Flight Aero Med · Traverse City, MIBuilt 1998 · S/N BB-1609 N6110Solidwood Aviation Express LLC · Waller, TXBuilt 1993 · S/N 650-7023 N6111VSfh Inc · Fargo, NDBuilt 2004 · S/N LJ-1711 N6112GCaptain Aviation LLC · Greenville, SCS/N FL-412 N6113ADelianides Aris Philip · Virginia Beach, VABuilt 1981 · S/N E-1941 N6113DMurfin Drilling Co Inc · Afton, OKS/N E-3513 N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890 N6119UQureshi Arif · Dansville, NYBuilt 1981 · S/N E-1948 N611AGN135pm LLC · Jensen Beach, FLBuilt 1968 · S/N E-90 N611ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 29753 N611ATN611at LLC · Punta Gorda, FLBuilt 1987 · S/N 650-0143 N611BT-2 Enterprises LLC · Walla Walla, WABuilt 1981 · S/N 31T-8166015 N611CRV J Coleman And Son · Ackerly, TXBuilt 1990 · S/N LJ-1234 N611EMLandlocked Company LLC · Dover, DES/N 611 N611GSGable S Corp · West Linn, ORBuilt 1997 · S/N 560-0436 N611GVGrant Aviation Inc · Anchorage, AKBuilt 2017 · S/N 208B5349 N611LLevesque Michael C · Hampden, MEBuilt 1999 · S/N 208-00299 N611RSWickman William S · Mckinleyville, CABuilt 1976 · S/N E-982 N611SDGreen Diamond One LLC · Knoxville, TNBuilt 1988 · S/N BB-1307 N611VGEncore Motors Of Melbourne Inc · Melbourne, FLBuilt 1990 · S/N 560-0091 N6125JBo LLC · Birmingham, ALBuilt 1982 · S/N E-1949 N6127XSalinas Manuel · Lamesa, TXBuilt 1960 · S/N 500A-970-32 N612ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30162 N612AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48290 N612BBBrazos Oaks Cloudco LLC · Dallas, TXBuilt 2006 · S/N 525-0629 N612FN612f LLC · Henderson, TNBuilt 1989 · S/N LJ1192 N612KPSmith Aviation Inc · Stamps, ARBuilt 1998 · S/N TH-1857 N612LMKag Aviation LLC · Nashville, TNBuilt 2013 · S/N FL-846 N612MAAndraos Aviation Solutions LLC · Northville, MIBuilt 1979 · S/N TH-975 N612PZLovrencevic Mark · Hanford, CABuilt 1983 · S/N E-2108 N612TNAustin Bill DBA · Sparta, TNBuilt 1981 · S/N TH-1272 N612VRWorldwide Option LLC · Lewes, DEBuilt 1979 · S/N 551-0026 N6132XKeller Keith E · Harvard, NEBuilt 1982 · S/N E-1950 N6134ZCji LLC · Winston Salem, NCBuilt 1981 · S/N E-1952 N6135CMiller William J · Ferriday, LABuilt 1981 · S/N E-1954 N6136XGo Leasing Company · Phillipsburg, KSBuilt 1960 · S/N 500A-926-25 N613AJMoonrise Acquisitions LLC · Sanford, FLBuilt 2024 · S/N 208B5804 N613ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30163 N613FCCobra Aviation Services LLC · Oklahoma City, OKBuilt 2014 · S/N 208B5151 N613GAGaf Holdings Inc · Visalia, CABuilt 2005 · S/N BB-1909 N613GGNcp Equipment LLC · Wilmington, DEBuilt 1998 · S/N LJ-1506 N613JGCj Aviation Partners LLC · Fort Worth, TXBuilt 1999 · S/N 525-0342 N613MWChip Aviation LLC · Sarasota, FLBuilt 1976 · S/N E-805

Back to AD 2006-16-18 R1