Registered aircraft · 16,280

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.

N251DXFlight Advantage Inc · Hot Springs, ARBuilt 2005 · S/N 41068 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251SRPaper Plane Aviation LLC · Sharpsburg, GABuilt 2022 · S/N 8862 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N2520CKrause Douglas R · Hinckley, OHBuilt 2005 · S/N 41516 N2520SPeregrine Air LLC · Colorado Springs, COBuilt 2005 · S/N 41073 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N2521WPc Enterprise Holdings LLC · Penfield, NYBuilt 2005 · S/N 41514 N2522FGentrius LLC · Austin, TXS/N 41049 N2522SEagleray Design LLC · Burlington, VTS/N 41083 N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030 N2524GTgc Aviation LLC · Houston, TXBuilt 2005 · S/N 41515 N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031 N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180 N2525KAvenue Enterprises Transportation LLC · Longboat Key, FLS/N 0890 N2525PAble II Orthotics And Prosthetics Inc · Lincoln, NEBuilt 2001 · S/N 1164 N2525VLow Ceiling Aviation LLC · Cincinnati, OHBuilt 2006 · S/N 2055 N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075 N2526BTimd Group USA Inc · Cheyenne, WYBuilt 2005 · S/N 41105 N2526LQuest Aero LLC · Zeeland, MIBuilt 2004 · S/N 41035 N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050 N2527ZQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 41502 N25281Relair LLC · Conesus, NYBuilt 2005 · S/N 41088 N2528DOlson Michael S · Ellsworth, KSBuilt 2005 · S/N 41523 N2528TN2528t LLC · Norcross, GABuilt 2004 · S/N 41029 N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051 N2528ZRothermel Aviation LLC · Klingerstown, PAS/N 41055 N2529PMatera Management LLC · Spanish Fork, UTBuilt 2005 · S/N 41521 N2529XCpdl Pm LLC · Dallas, TXBuilt 2012 · S/N 4636553 N252AXFrequency Change Aviation Services Inc · Nashville, TNBuilt 2004 · S/N 40.392 N252CValiair Lc Trustee · Casper, WYBuilt 2012 · S/N 4697498 N252DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010033 N252FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10061 N252GKBlue Sky Aviation Management LLC · New York, NYBuilt 2024 · S/N 10125 N252MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881444 N252MJThorpe Curtis D · Fredericksburg, TXBuilt 2012 · S/N 4636548 N252PDeck Air LLC · Kalamazoo, MIBuilt 2004 · S/N 1002 N252PFJatayu LLC · North Andover, MABuilt 2022 · S/N 8535 N252TPCirrus Design Corp · Duluth, MNS/N 11811 N2531YPremier Aviation LLC · Sioux Falls, SDBuilt 1985 · S/N 28-8590083 N25324Central Valley Air LLC · Logan, UTBuilt 2013 · S/N 4697519 N2533KDomicile Capital LLC · Monterey, CABuilt 2005 · S/N 41531 N2533XFmfa Inc · Wilmington, DES/N 28-8590086 N2535LK & L Adventures LLC · Moses Lake, WABuilt 2005 · S/N 41082 N2535PN2535p LLC · Verona, WIBuilt 2006 · S/N 41568 N2535UMyer Mark A · Sandusky, OHBuilt 1979 · S/N 28-8090054 N2535XAviator Ventures LLC · Valrico, FLBuilt 2006 · S/N 41573 N25367Robinson Stephen C · Garrison, NDBuilt 2005 · S/N 41503

Back to AD 2008-06-28 R1