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.

N4134MHansen Kirk · Bayside, WIBuilt 1998 · S/N 3246124 N4134TDavis Stephen · Madera, CABuilt 1999 · S/N 2843206 N4135DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 2843219 N4135JValiair Limited Company Trustee · Casper, WYS/N 3246127 N4135WTexins Flying Club · Mckinney, TXBuilt 1999 · S/N 2843244 N4135ZSsk Ventures LLC · Eagle, COBuilt 1999 · S/N 3449134 N4136SCrass David B · Aledo, TXBuilt 1999 · S/N 3257093 N4136THot Wings LLC · Wilmington, DEBuilt 1999 · S/N 3246152 N4136ZBrazit LLC · Miami, FLBuilt 1999 · S/N 3246137 N4137LLuv 2 Fly Ada LLC · Ada, OKBuilt 1999 · S/N 2843249 N4137PGreene Marble & Granite Co · Manalapan, NJBuilt 1999 · S/N 3257086 N4138QSteward John A · Atlanta, GABuilt 1999 · S/N 3246139 N4138WK2 Aviation LLC · Sanford, NCBuilt 1999 · S/N 3449122 N4139LCj Horizons LLC · Amboy, MNS/N 3449117 N4139RPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1999 · S/N 3246130 N4139SKdj LLC · Wilmington, DEBuilt 1999 · S/N 3257099 N4139TMalibu Mirage Inc · Eugene, ORFirst renewal noticeBuilt 1998 · S/N 4636179 N4139VBourgogne Aviation Inc Owner Trustee · Wilmington, DEBuilt 1999 · S/N 3257085 N413AKAlhambra Aviation LLC · San Mateo, CABuilt 2016 · S/N 4429 N413AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8815 N413CNOa2 Aviation LLC · Gallatin, TNBuilt 2010 · S/N 3651 N413CPDean Taylor LLC · Palm Coast, FLBuilt 2008 · S/N 3257 N413DPYale Companies LLC DBA · Fishers, INBuilt 2006 · S/N 4496234 N413ETRaviv Barak Trustee · Beverly Hills, CABuilt 2006 · S/N 1689 N413HCNeed For Speed LLC · Tyler, TXS/N 32R-8429012 N413KTAce Tomato Company LLC · Mcgregor, TXBuilt 2005 · S/N 2843608 N413MRVelocity Airways LLC · Olathe, KSBuilt 2018 · S/N 2447 N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006 N413PTag Aviation LLC · Larwill, INBuilt 2004 · S/N 1073 N413PTAerobear LLC · Vero Beach, FLBuilt 2012 · S/N 2133 N413RSStewart Rentals LLC · Tampa, FLBuilt 2026 · S/N 11460 N413SRBroussard Knoll Law Firm LLC · Marksville, LABuilt 2006 · S/N 1936 N413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252 N413TLSnapper Kai LLC · Kerrville, TXBuilt 2016 · S/N 4338 N413WTFlytek LLC · Copperopolis, CABuilt 2018 · S/N 2409 N4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228 N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233 N4141TPremier Properties And Investments LLC · Tarkio, MOBuilt 2005 · S/N 1442 N4141UMoss James L · Lansing, IABuilt 1998 · S/N 2843125 N4141XSpuddy Properties LLC · Leclaire, IABuilt 2005 · S/N 1716 N4142QWisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1999 · S/N 2843207 N4142RValiair Lc Trustee · Casper, WYBuilt 1999 · S/N 3449140 N4142VLuccarelli Christopher · Merrimack, NHBuilt 1998 · S/N 3449084 N4143ASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843217 N4143NHouk Nathan · Morrisonville, NYBuilt 1999 · S/N 3449133 N4143USwerczek Gerald Edward Jr · Tallahassee, FLBuilt 1999 · S/N 2843308 N4144KBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843145 N4144PChandler Air Service Inc · Chandler, AZBuilt 1998 · S/N 2843121 N4144XSkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843267 N41453Swfl Aviation LLC · Cape Coral, FLBuilt 1999 · S/N 3246148

Back to AD 2008-06-28 R1