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.

N128PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 0218 N128REHotel Juliet Romeo Echo LLC · Crosby, TXBuilt 2025 · S/N 11003 N128USPacific Diamond LLC · Moraga, CABuilt 2006 · S/N 40.728 N128VVolar Vi LLC · Edmond, OKBuilt 2024 · S/N 9974 N128WCAgdj Holdings LLC · Brookshire, TXBuilt 2019 · S/N 2473 N1290CPepper & Acorn LLC · Henderson, NVBuilt 2003 · S/N 0512 N1290HWeiss Gregory K · Manitou Springs, COS/N 28-7716012 N1291NWestern States Liquefied Petroleum Gas Co · Elko, NVBuilt 2009 · S/N 411128 N1293CTexas Blue Skies Aviation LLC · Canyon Lake, TXBuilt 2003 · S/N 0565 N1294PBagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41660 N1295JN1295j Corp Trustee · Wilmington, DEBuilt 2006 · S/N 41641 N1297EWood Paul Richard · Cumming, GABuilt 2008 · S/N 411097 N1297LOklahoma Cirrus LLC · Mclean, VABuilt 2003 · S/N 0713 N1298GMango Tango Air LLC · Cantonment, FLBuilt 2007 · S/N 42533 N1299HB&C Aviation LLC · Helena, MTBuilt 2008 · S/N 411099 N1299KOrange And Black LLC · Lewes, DEBuilt 2008 · S/N 411062 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129EJShelbyville Auto Sales LLC · Shelbyville, TNBuilt 2001 · S/N 4697065 N129GPPafford Holdings LLC · Ruston, LABuilt 2005 · S/N 1366 N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N129SRRobin Crest Inc Trustee · Wilmington, DES/N 1884 N12ANFreedom Okc Aircraft LLC · Oklahoma City, OKBuilt 2024 · S/N 10051 N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293 N12CDJacoby Robert L · San Marcos, TXBuilt 2008 · S/N 1890 N12EDKinney Aviation LLC · Bethany Beach, DEBuilt 2026 · S/N 11420 N12ENGallagher John · Ashburn, VABuilt 2025 · S/N 10837 N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439 N12FZCastelino Sanjay · Austin, TXBuilt 2006 · S/N 1670 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131 N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255 N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49 N12LCLc Aviation LLC · Lynnfield, MABuilt 2013 · S/N 3952 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N12PTN12pt LLC · Wilmington, DEBuilt 2022 · S/N 8544 N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412 N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417 N12WBOld Man Aviation LLC · Saint Louis, MOBuilt 2024 · S/N 9981 N12XYShramek Troy · Bossier City, LABuilt 2007 · S/N 42545 N12ZGN12zg Pm LLC · Provo, UTBuilt 2020 · S/N 2600 N1302CFun Flying LLC · Granbury, TXBuilt 2006 · S/N 41632 N1303ASitehawks Aviation Inc · Jacksonville, FLS/N 3712 N1303HFire Up The Cirrus Penny LLC · Alexandria, VABuilt 2013 · S/N 3945 N1307HDileo Steven · Gallatin, TNS/N 28-7716015 N1308LQualitair LLC · MichelstadtBuilt 2006 · S/N 41590 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130JMRegistration Pending · Tampa, FLRegistration pendingBuilt 1982 · S/N 28-8390036 N130MBAirdale Aviation LLC · Glade Hill, VABuilt 2005 · S/N 1516 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477

Back to AD 2008-06-28 R1