Registered aircraft · 6,915

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N13832Davey Spencer J · Spokane, WAS/N 27-4474 N13839Tyler Petroleum Inc · Tyler, TXBuilt 1970 · S/N 27-4480 N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500 N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503 N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517 N1389BColumbia Safety Medical LLC · Kennewick, WABuilt 2005 · S/N T18208455 N138AZTablemax Aeronautics LLC · El Paso, TXBuilt 2004 · S/N T18208355 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533 N1391AAqua Aviation LLC · Danville, CABuilt 2007 · S/N T18208723 N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117 N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567 N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598 N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600 N13984Smith Aircraft Holdings Inc · Wilmington, DEBuilt 1970 · S/N 27-4602 N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605 N13998Granger Vic · Union Grove, ALS/N 27-4616 N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570 N139HPCalifornia Highway Patrol · Sacramento, CABuilt 2015 · S/N GA8-TC-320-15-224 N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505 N139WTCotton Business Enterprises LLC · Hummelstown, PABuilt 2000 · S/N 27-0283 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411 N13CEWilley R Scott · Layton, UTBuilt 1970 · S/N 31007 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046 N13JBAltitude Aviation Services LLC · Mountain Home, IDBuilt 1976 · S/N 61P-0323-090 N13NEQualitair LLC Trustee · MichelstadtBuilt 1984 · S/N 31P-8414035 N13RZBjornstad Eugene N Trustee · Girdwood, AKBuilt 1989 · S/N 570 N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069 N13WNRegistered aircraftBuilt 2026 · S/N T20609838 N14005Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-4623 N14012Rock Valley College · Rockford, ILBuilt 1971 · S/N 27-4629 N14028Stoks Derek R · Canby, MNS/N 27-4689 N14036Booth Donald V · Denison, TXBuilt 1971 · S/N 27-4648 N14040Island Aviation Inc Trustee · Wilmington, DEBuilt 1971 · S/N 27-4654 N1404YDavidson Bill · Lewisville, TXBuilt 1986 · S/N 45 N14051Sams Way · Eagle Mountain, UTBuilt 1971 · S/N 27-4663 N1409XHolmberg Shane A · Fairbanks, AKBuilt 1975 · S/N 32-7540155 N140DCCheely Matthew G · Hillsdale, MIBuilt 2003 · S/N 58 N140HPCalifornia Highway Patrol · Sacramento, CABuilt 2013 · S/N GA8-TC-320-13-198 N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051 N140RMMckenzie Michael C · Ventura, CABuilt 2000 · S/N 27-0287 N140TAGuggenair LLC · Carbondale, COBuilt 2002 · S/N T18208140 N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701 N14138Island Bound LLC · Dunedin, FLS/N 27-4704 N14149Ninja Turtle LLC · Orlando, FLBuilt 1971 · S/N 27-4712 N1419XWhitman Aviation LLC · Morganville, NJS/N 32-7540160 N141CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609135 N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117 N141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244

Back to AD 71-13-01 R1