Registered aircraft · 1,017

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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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.

N208SNStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2112 N208SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 208B1306 N208TFMartinaire Aviation LLC · Addison, TXBuilt 1997 · S/N 208B0592 N208TMRedding Aero Enterprises Inc · Redding, CABuilt 1994 · S/N 208B0413 N208TRSouth Aero Inc · Albuquerque, NMBuilt 2005 · S/N 208B1151 N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671 N208UUSpeedstar Express LLC · Carson City, NVBuilt 1997 · S/N 208B0604 N208WSilver Mountain LLC · Port Alsworth, AKBuilt 2015 · S/N 208B5224 N208WBAlgot Bernhard Ltd · Anchorage, AKS/N 208B2230 N208WFWipaire Inc · South Saint Paul, MNBuilt 2003 · S/N 208B1042 N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721 N208YYAircraft Structures International Corp · Enid, OKBuilt 1995 · S/N 208B0453 N208ZZSpeedstar Express LLC · Carson City, NVBuilt 1991 · S/N 208B0260 N209JPBeta Fleet LLC · South Burlington, VTBuilt 2007 · S/N 20800409 N20AWWilliams Aviation Assets LLC · Jupiter, FLBuilt 2019 · S/N 208B5534 N2114GMission Aviation Fellowship · Nampa, IDBuilt 1999 · S/N 208B0782 N212CPTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1996 · S/N 208B0531 N213LAJet Rider LLC · Middletown, DEBuilt 2004 · S/N 208B1096 N215BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5232 N215BTScreen Star Inc Trustee · Wilmington, DEBuilt 2009 · S/N 20800517 N215MCTatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1999 · S/N 208B0730 N215TXTexas Dept Of Public Safety · Austin, TXBuilt 2012 · S/N 20800542 N216RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0379 N218LCWright Air Service Inc · Fairbanks, AKBuilt 2018 · S/N 208B5476 N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384 N21955Pah 6 Inc · Houston, TXBuilt 2017 · S/N 208B5341 N220EAEagle Air Transport Inc · Ottawa, ILS/N 208B0151 N220XWMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0822 N223KHAirprop Inc · Portsmouth, NHBuilt 2021 · S/N 208B5621 N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688 N228NMpe Beaver LLC · Seattle, WABuilt 2020 · S/N 208B5601 N228NDNorth Dakota Dept Of Transportation · Bismarck, NDBuilt 2010 · S/N 20800520 N22KWFinn Capital LLC · San Mateo, CABuilt 2015 · S/N 208B5210 N22TENv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2007 · S/N 208B1266 N22W22w LLC · Tacoma, WABuilt 2020 · S/N 208B5614 N2329FFlorida Aeronautical Survey Technologies · Fort Lauderdale, FLBuilt 2011 · S/N 208B2312 N233PCWright Air Service Inc · Fairbanks, AKBuilt 2006 · S/N 208B1179 N2343XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 208B2343 N234WLGalaxy Sea Lift LLC · New York, NYS/N 208B5794 N236KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2034 N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368 N240GSCessna 208b-0994 Inc Trustee · Wilmington, DES/N 208B0994 N241BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5208 N242EWEco Window Systems LLC · Medley, FLBuilt 2015 · S/N 208B5180 N242RG242rg LLC · Miami, FLBuilt 2026 · S/N 208B5922 N243PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5855 N245JSFe Caravan LLC · Kinston, NCBuilt 2014 · S/N 208B5154 N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720 N247JPSpirit Air Inc · Salmon, IDBuilt 2013 · S/N 208B5047 N248BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5796

Back to AD 2006-01-11 R1