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.

N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524 N4415FB&G Air Inc · Morgan City, LABuilt 2002 · S/N LJ-1675 N4415LIdaho State University · Pocatello, IDS/N BE67 N4417WReyling Joseph E · Glasgow, MTBuilt 1974 · S/N E-529 N442ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43293 N442HRHotel Romeo LLC · Nichols Hills, OKBuilt 2023 · S/N 525-1158 N442KAMoore Horizons LLC · Murrells Inlet, SCBuilt 1978 · S/N BB442 N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N442MSWd Aviation Group Inc · Atlanta, GAS/N NA0460 N442PLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1679 N442WHayden Stephen Lin · Raton, NMBuilt 1987 · S/N E-2356 N4432YFraiman Douglas E · Homer, AKBuilt 1979 · S/N E-1614 N4434VAske Karl · Brainerd, MNBuilt 1947 · S/N D-1239 N4434WP Scarlett Inc · Plattsmouth, NEBuilt 1975 · S/N E-742 N443BCTothemoon LLC · Salt Lake City, UTBuilt 1997 · S/N 525-0189 N443CLSkiing Aircraft Co LLC · Bloomfield Hills, MIBuilt 1979 · S/N LW-318 N443EA500 Knot LLC · Granbury, TXBuilt 1996 · S/N 560-0400 N443JPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 208B5043 N443PFrederick Investment Corp · Raleigh, NCBuilt 1999 · S/N TH-1914 N4446VSahagun Salvador G · Bothell, WABuilt 1948 · S/N D-1256 N4447WJvs86 LLC · Scottsdale, AZBuilt 1974 · S/N LJ-627 N4449WJameson Clarke Enterprises LLC · Houston, TXBuilt 1974 · S/N TH-451 N4449YTx Waste Ventures LLC · Caddo Mills, TXBuilt 1975 · S/N E-657 N444ADApex Aviation Holding LLC · Kalispell, MTBuilt 1980 · S/N BB-733 N444BDAddington James T · Denton, TXBuilt 1960 · S/N 94629 N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893 N444CWTexas Aero Jet Sales 1 LLC · Wilmington, DEBuilt 1984 · S/N 650-0064 N444GGLipsitz Melvin Jr · Waco, TXBuilt 1994 · S/N 560-0262 N444HDChado Richard P II · Rancho Cucamonga, CAS/N 421C0480 N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N444JFBod Aviation LLC · Los Angeles, CABuilt 1999 · S/N 258431 N444KASky Hye Air LLC · Hye, TXBuilt 1989 · S/N BB1318 N444LPierwest Aviation LLC · Tulsa, OKBuilt 1980 · S/N LW-344 N444LPTri Supply LLC · Beaumont, TXS/N BB-1816 N444PGN444pg Aviation LLC · Charleston, SCBuilt 1998 · S/N E3218 N444RFCascadian I LLC · Bellevue, WABuilt 2001 · S/N 560-0559 N444RKOrmond Beach Jet LLC · Ormond Beach, FLBuilt 1983 · S/N BE-137 N444WAWiseman Aviation Inc · Flagstaff, AZBuilt 1961 · S/N 1130-60 N444WDFlyto LLC · Indianapolis, INBuilt 1988 · S/N 96006 N444WELiberty Steaks LLC · Latham, NYBuilt 2004 · S/N E-3579 N444WGSchmucker Real Estate Holdings Lp · Wilmington, DEBuilt 1981 · S/N 31T-8166054 N444ZHBma Leasing LLC · Greensboro, NCBuilt 1997 · S/N 560-0444 N4451SCaporale Ron · Dillon, MTBuilt 1975 · S/N E-683 N4451VBeicker Dennie L · Hernando, MSBuilt 1948 · S/N D-1266 N4456SFressh Air LLC · Vancouver, WABuilt 1975 · S/N E-688 N4456WMetal Finishing Co Inc · Wichita, KSBuilt 1974 · S/N E-537 N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692 N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415 N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691 N4464WMantei & Associates Ltd · Lexington, SCBuilt 1974 · S/N E-543

Back to AD 2006-16-18 R1