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.

N599BB3gs Air LLC · Fort Myers, FLBuilt 1976 · S/N LJ-699 N599BGGibbs Technology Co · Maryland Heights, MOBuilt 2017 · S/N FL-1111 N599KDEncore One LLC · Conway, ARBuilt 2007 · S/N 560-0755 N599MBMani Hana Ac 599mb (De) LLC · West Hollywood, CABuilt 2019 · S/N 208B5547 N599RMState Technical College Of Missouri · Linn, MOBuilt 1979 · S/N 501-0099 N59ALBilly Ray Casteel LLC · Russellville, ALBuilt 1983 · S/N LA-208 N59BQMod Flying LLC · Elkhorn, NES/N E-2273 N59BSSlx Air LLC · Waxhaw, NCBuilt 1996 · S/N 525-0169 N59BWStandridge Color Corp · Social Circle, GABuilt 1982 · S/N LA-170 N59CMCalled To Care Residential Facility LLC · Goodyear, AZBuilt 1979 · S/N E-1377 N59CTTornado Alley Turbo Inc · Ada, OKBuilt 1980 · S/N E-1719 N59DFRlc Partners LLC · Grand Prairie, TXBuilt 1991 · S/N 560-0098 N59EKCrosby Richard · Macon, GAS/N LA-58 N59FGState Of California · Sacramento, CABuilt 2024 · S/N 20800705 N59FHSpecialty Air Partners LLC · Mooresville, NCBuilt 1995 · S/N 525-0105 N59FTSt Andrews Aircraft LLC · West Palm Beach, FLBuilt 1986 · S/N 650-0123 N59GBTh Leasing Corp · Wilmington, DEBuilt 1982 · S/N 551-0060 N59HMBaron International Ventures LLC · West Palm Beach, FLBuilt 1975 · S/N TH-635 N59JBAero Buelo LLC · Jasper, TXBuilt 1982 · S/N E-2045 N59KAParagon Office Services LLC · Dallas, TXS/N LJ-589 N59MDynamic Avlease Inc · Bridgewater, VAS/N BB-1419 N59NWScanair LLC · Dover, DEBuilt 2013 · S/N 20800546 N59PJTad Holdings LLC · Little Falls, MNBuilt 1987 · S/N E-2395 N59YPNextgen Flying LLC · The Villages, FLBuilt 1998 · S/N 275 N5AETenax Aerospace LLC · Ridgeland, MSS/N BB-1891 N5AFCavu Charters LLC · Stuart, FLBuilt 2023 · S/N 525-1145 N5AHEmpire Air LLC · Indio, CABuilt 1980 · S/N LA-53 N5ALSchapansky Justin · Mount Airy, GABuilt 1973 · S/N TH-356 N5BZBad Bird LLC · Elon, NCBuilt 1975 · S/N TH-662 N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187 N5DCSturges Jason Charles · Phoenix, AZBuilt 1976 · S/N E-887 N5DLAmerson Loyd Scott · Douglas, GABuilt 1979 · S/N E-1515 N5JETailwinds 350 LLC · Porter, TXBuilt 1989 · S/N FL-3 N5NNRkgrier LLC · Beckley, WVS/N 421C0446 N5PXRed Poodles LLC · Boston, MABuilt 1979 · S/N BB-554 N5RLUnder The Radar LLC · Dover, DEBuilt 1981 · S/N 501-0228 N5STDe Paz Aviation LLC · Coral Gables, FLBuilt 1977 · S/N BB-289 N5TADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N LJ-724 N5TRN535j LLC · Bismarck, NDBuilt 1981 · S/N 551-0351 N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101 N5UUFlid Aviation LLC · Birmingham, ALBuilt 1998 · S/N 560-0457 N5WCMidstar Transport LLC · Midland, TXBuilt 1997 · S/N 5600403 N5WFMociva Inc · Del Mar, CABuilt 1994 · S/N E-2892 N5WMMerrell Warren · Idalou, TXBuilt 1975 · S/N E-649 N5WTShell Air LLC · Liberty Township, OHBuilt 2003 · S/N 560-0635 N5XMMiddle Tennessee State University · Murfreesboro, TNBuilt 1994 · S/N FL-115 N5XRAviacion Del Oeste Inc · Mayaguez, PRBuilt 1982 · S/N 063 N5ZNPriddy Robert C · Graford, TXS/N 501-0115 N5ZRBeasley Timber Co Inc · Hazlehurst, GABuilt 2005 · S/N TH-2128 N60036Textron Aviation Inc · Wichita, KSBuilt 2026 · S/N 208B5966

Back to AD 2006-16-18 R1