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.

N231LLTen-Xray LLC · Woodside, NYBuilt 2002 · S/N 0199 N231MAGolden Age N231ma LLC · Norwalk, IABuilt 2022 · S/N 2881564 N231SGDeziel Aviation LLC · Jupiter, FLBuilt 2015 · S/N 2280 N231WMA Davtian M D Medical Services Inc DBA · Glendale, CAS/N 0900 N231WURegistered aircraftBuilt 2006 · S/N 4496231 N2321MPartridge John M · Danville, CABuilt 1977 · S/N 28-7816278 N2321THobson Joseph C · Beverly Hills, FLBuilt 1971 · S/N 28R-7130009 N2325DBeck Sod Farm Inc · Palms, MIBuilt 2008 · S/N 4697339 N2325JLesterville Land Holdings LLC · Ellington, MOBuilt 2010 · S/N 4636480 N2326VEby Thomas R · Winter Springs, FLBuilt 1985 · S/N 28-8590067 N232BBKimbrough Aviation LLC · Oakwood, OHBuilt 2005 · S/N 40.531 N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187 N232CHHoover Charles C Jr · Lake Wales, FLBuilt 2006 · S/N 41696 N232DSSmith William · Colorado Springs, COBuilt 2005 · S/N 40.553 N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032 N232DYValiair Lc Trustee · Casper, WYS/N 11701 N232FJConstruct Air LLC · Osage Beach, MOBuilt 2002 · S/N 0338 N232MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881983 N232MMBuilder Tony Hirst LLC · Kittrell, NCBuilt 2006 · S/N 2302 N232NEThf Aviation LLC · Naples, FLBuilt 2023 · S/N 9265 N232PLDcosta John A · San Jose, CABuilt 2001 · S/N 1159 N232SPTucker Adam C · Clermont, FLBuilt 1978 · S/N 28-7990205 N232SRRegistration Pending · Vandalia, OHRegistration pendingBuilt 2006 · S/N 1990 N232TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881550 N232TSTwo Tango Sierra LLC · Edmond, OKBuilt 1982 · S/N 32R-8229041 N232TXHaugo Bruce · Sarasota, FLBuilt 2008 · S/N 40.991 N232WAFremont Motors Rocksprings Inc · Rawlins, WYBuilt 1981 · S/N 34-8233020 N2330TSteele Jackie L · London, KYS/N 28R-7130010 N2331MSmith Ctr Kite Club Inc · Smith Center, KSBuilt 1977 · S/N 28-7890247 N233AMHsing Mitchell · Saratoga, CABuilt 2006 · S/N 40.733 N233CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881389 N233CDGottafly LLC · Alpharetta, GABuilt 2001 · S/N 1119 N233DYValiair Limited Company Trustee · Casper, WYS/N 11705 N233LSSelznick Larry Trustee · Stevenson Ranch, CABuilt 2004 · S/N 0885 N233MAMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.511 N233MMHigh Way LLC · Wilmington, DEBuilt 2017 · S/N 4445 N233NCEnergyview LLC · Tioga, NDBuilt 2012 · S/N 3905 N233PJLwkimber Interests Management LLC · Houston, TXBuilt 1986 · S/N 441-0362 N233RCRico Marketing Corporation · Flint, MIBuilt 1982 · S/N 441-0263 N233SBC2c LLC · Hamilton, MTBuilt 2002 · S/N 0242 N233SROharra Robert J · Buckley, WAS/N 2185 N233WZInduction Aviation LLC · Lewes, DEBuilt 2006 · S/N 1752 N234AGLop LLC · Orangeburg, SCBuilt 2011 · S/N 4636510 N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008 N234AKKihneman David J · Spring, TXBuilt 2007 · S/N 2878 N234BJJmc Commercial Contractors LLC · Porter, TXBuilt 2007 · S/N 2541 N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369 N234CWWright Caleb · Douglas, GABuilt 2015 · S/N 4261 N234CZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 2548 N234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeBuilt 1983 · S/N 32R-8329029

Back to AD 2008-06-28 R1