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.

N827NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881289 N827RBMjm Aviation LLC · Oak Hill, VABuilt 2025 · S/N 10772 N827RJN827rj LLC · Ogden, UTBuilt 2012 · S/N 4636526 N827SStamp Jeffrey · Little Rock, ARBuilt 2002 · S/N 0362 N827URJoby Aero Inc · Santa Cruz, CABuilt 2016 · S/N 4403 N827WFCarlton Paul K Jr · College Station, TXBuilt 2003 · S/N 0667 N8282KNoyes Tony · Lewisville, TXS/N 32R-8129002 N8282NMercury Aircraft Holdings Inc · West Monroe, LABuilt 1980 · S/N 32R-8129003 N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060 N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066 N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071 N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065 N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064 N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066 N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073 N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005 N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110 N8287UPhillips Harry R · Oxford, PABuilt 1982 · S/N 34-8333027 N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020 N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237 N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071 N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072 N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080 N828ABChasen Dreams LLC · Hurricane, WVBuilt 2005 · S/N 1419 N828ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496550 N828BRDouma Stephen M · Odenton, MDBuilt 2006 · S/N 1697 N828CCoriolis Inc · Brooklyn, NYBuilt 2002 · S/N 0396 N828DFKingfisher Aviation LLC · Fort Wayne, INS/N 0731 N828DTTspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1648 N828ECPrescient Aviation LLC · Los Angeles, CAS/N 1200 N828EXHorizon Strategies Aviation LLC · Dover, DEBuilt 2013 · S/N 3927 N828GGOrtho Hand Aviation LLC · Lewes, DEBuilt 2015 · S/N 4294 N828GPGreene And Phillips Attorneys At Law LLC · Mobile, ALBuilt 2011 · S/N 4636514 N828KPKapa International · Santa Monica, CABuilt 2005 · S/N 1456 N828LEKnights Templar Aviation LLC DBA · Rossville, TNBuilt 2008 · S/N 3178 N828MEHungerford Properties LLC · Cockeysville, MDBuilt 2006 · S/N 1943 N828MRLooking Beyond LLC · Burlington, VTBuilt 2012 · S/N 3885 N828MWCoop Michael P Sr · Sylva, NCBuilt 2025 · S/N 10813 N828RRNorthern Lights Sc LLC · Wilmington, DEBuilt 2016 · S/N 4337 N828TMTaylor Aero LLC · Lewes, DEBuilt 2004 · S/N 0943 N828VTParque Colina LLC · San Antonio, TXBuilt 2009 · S/N 3587 N82910Great Bay Air LLC · North Hampton, NHBuilt 1982 · S/N 32R-8313006 N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007 N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009 N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001 N8294KAdvantage 94 Kilo LLC · Grosse Pointe Park, MIBuilt 1980 · S/N 32R-8113007 N8294LAts Tennessee Inc · Oneida, TNBuilt 1982 · S/N 28-8316011 N82953Sky Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190088 N8295HAnywhere Atp LLC · Mt Juliet, TNBuilt 1982 · S/N 28-8316013 N8295TFlight Services Inc · Headland, ALBuilt 1980 · S/N 28-8116082

Back to AD 2008-06-28 R1