Registered aircraft · 16,295

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N1271T3dg LLC · Sylva, NCBuilt 2006 · S/N 41655 N12727Sunset Spas LLC · Chandler, AZBuilt 2007 · S/N 41769 N1272NEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 41650 N12744Esa Es Corp · Glen Cove, NYBuilt 2006 · S/N 41690 N12747Six Bravo Period LLC · Miami, FLBuilt 2018 · S/N 4680 N1274AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 41762 N1274XFly El Paso LLC · El Paso, TXBuilt 2008 · S/N 411077 N1276LD Porter Enterprises LLC · Dickinson, NDBuilt 2006 · S/N 41651 N1276ZMcarthur Air LLC · Mcarthur, CABuilt 2009 · S/N 411120 N1278DRegistered aircraftBuilt 2007 · S/N 42532 N1278ZNew Hartford Psychiatric Services P L L C · Whitesboro, NYBuilt 2006 · S/N 41658 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127CBird Brian A · Duluth, MNBuilt 2013 · S/N 4636604 N127CDRegistered aircraftBuilt 2000 · S/N 1027 N127DCMountain Aviation LLC · Crossville, TNBuilt 2011 · S/N 3802 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343 N127KCUtah State University · Logan, UTBuilt 2011 · S/N 40.1127 N127SKVoyager Exploration Inc · Marblehead, OHBuilt 2002 · S/N 0226 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438 N1280ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 41654 N1281Cirrusazflmi LLC · Midland, MIBuilt 2005 · S/N 1581 N1281FPantheon Aviation LLC · Franklin, NCBuilt 2023 · S/N 9379 N1282DJas & Jls Holdings LLC · Lake Point, UTBuilt 2006 · S/N 41642 N1282MCastaneda Carlos · Clyde Hill, WABuilt 2008 · S/N 411083 N1284CCirrus N1284c LLC · Oakland Park, FLBuilt 2003 · S/N 1321 N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304 N1285D6886 Aviation LLC · Mesa, AZS/N 41638 N1285VCarrobby LLC · Wilmington, DEBuilt 2008 · S/N 411085 N1286CCalabarb Aviation LLC · Mesa, AZBuilt 2006 · S/N 41591 N1286GRegistered aircraftS/N 28-7990076 N1287C907th Flight Squadron Inc · Wilmington, DEBuilt 2003 · S/N 1311 N1287DRcad LLC · Wilmington, DEBuilt 2009 · S/N 411144 N1288HFly By Knight Inc · Hammond, LABuilt 1976 · S/N 28-7716011 N1288NTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 411088 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128BVAbel Donald B · Greenville, WIBuilt 2006 · S/N 2060 N128CTaylor Chevrolet Co · Rexburg, IDBuilt 2013 · S/N 4697528 N128CDMetamorphosis Publishing LLC · Hamilton, MTBuilt 2000 · S/N 1024 N128CWTres Ninos LLC · Dover, DEBuilt 2013 · S/N 3949 N128EDSimply Living LLC · Fort Myers, FLBuilt 2000 · S/N 4636258 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N128FAWe So Fly LLC · Edgemoor, SCBuilt 2004 · S/N 1470 N128FTN128ft LLC · Erie, COBuilt 2008 · S/N 3116 N128GRJaques Stanley S · Cassville, MOBuilt 1968 · S/N 28R-30806 N128HBSowle LLC · Tampa, FLBuilt 2007 · S/N 3257479 N128JFFloyd Stephen M · Spotsylvania, VABuilt 2003 · S/N 1316 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171

Back to AD 2008-06-28 R1