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.

N5347VDe Boissard Karen · New York, NYS/N 4697126 N5348MLooney Tunes Air LLC · Omaha, NEBuilt 2004 · S/N 0792 N5349MWhiskey Bravo LLC · Clarksville, TNBuilt 2002 · S/N 3257307 N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754 N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278 N534CDAdvanced Tree Care Inc · Lincolnshire, ILBuilt 2005 · S/N 1623 N534CPOn Duty Health - Texas Pllc · Redlands, CABuilt 2008 · S/N 3035 N534MAPn4 Aviation Holdings LLC · Bishop, CABuilt 2003 · S/N 3449278 N534SCSpartan Education LLC · Tulsa, OKS/N 2881320 N534SRArrowhead Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 1079 N5350GSmolin Matthew R · Durango, COS/N 3449246 N53511Didia Robert · Fraser, MIBuilt 2004 · S/N 0864 N53512Rapp Steven B · Hawthorne, CABuilt 2004 · S/N 0868 N53516Flight Group LLC · Bend, ORBuilt 2002 · S/N 4697132 N53517Papadelta Inc Trustee · Wilmington, DEBuilt 2002 · S/N 4636330 N53521Sprague Wolcott E · Westlake Village, CABuilt 2002 · S/N 3257284 N53533Tfw Enterprise Holding LLC · New York, NYS/N 2843579 N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096 N5353UTurbo Arrow Aviation LLC · Knoxville, TNBuilt 2002 · S/N 3257275 N5353VMidwest Ventures LLC · Wichita, KSBuilt 2002 · S/N 4697141 N5354KWassum Kevin Leroy · Apollo Beach, FLBuilt 2005 · S/N 3255033 N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160 N5354VHowe Andrew · Wshngtn Xing, PABuilt 2002 · S/N 3257298 N53550Kansas City Aviation Center Inc · Olathe, KSS/N 2843451 N5355SJohn Galt Industries LLC · Charlevoix, MIBuilt 2002 · S/N 4697136 N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164 N5356XSkywest Leasing Inc · St George, UTS/N 2843521 N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528 N53572Arb Aviation LLC · Palm Harbor, FLBuilt 2002 · S/N 3246208 N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537 N5357NSkywest Leasing Inc · St George, UTS/N 2843519 N5358FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3257312 N5358JAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2002 · S/N 4697140 N53592Gulfstream Design Associates Inc · Delray Beach, FLBuilt 2003 · S/N 3257317 N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098 N5359JVander Leest Roland R · Lyndon, ILBuilt 2002 · S/N 3449267 N535JRGreenville Pickens Roundtrac LLC · Easley, SCBuilt 2006 · S/N 4697253 N535LBJet Quest LLC · West Palm Beach, FLS/N 2873 N535PGSs Aviation LLC · Westlake, LABuilt 2005 · S/N 1293 N535RTN535rt LLC · Provo, UTS/N 0407 N535SCardoza Real Estate Inc · Eagle, IDBuilt 2001 · S/N 0014 N5360KN5360k LLC · Lebanon, MOBuilt 2002 · S/N 3246207 N5361AChavers Construction Inc · Cantonment, FLBuilt 2002 · S/N 4697144 N5361JJones David F · Murfreesboro, TNS/N 3257301 N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549 N5361RLtd Aviation LLC · Dubois, PAS/N 3449271 N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555 N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559 N53646Fhas LLC · Cassopolis, MIS/N 3246214 N53651Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 2843565

Back to AD 2008-06-28 R1