Registered aircraft · 6,916

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.

N5287SBas Part Sales LLC · Greeley, COS/N 27-0244 N5289HClarke Simon P · Seattle, WABuilt 2009 · S/N T18208936 N528HWyoming Management LLC · Sheridan, WYBuilt 2020 · S/N T20609608 N528LSYoung Robert A · Mount Desert, MEBuilt 2007 · S/N T18208798 N528WBAdvantage U S A A Inc · Spring Branch, TXBuilt 2008 · S/N T20608807 N5293PRogue Aero LLC · Grants Pass, ORBuilt 2010 · S/N T20608962 N5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeBuilt 1972 · S/N 32-7240104 N529ECAlpha Tango LLC · Little River, SCBuilt 1975 · S/N 32R-7680072 N529HCJ&J Aviation LLC · Thedford, NEBuilt 2008 · S/N 4692039 N529LBAeronova LLC · Lexington, KYBuilt 2012 · S/N 4636544 N529PTLt Express LLC · Carson City, NVBuilt 2002 · S/N T18208119 N529RGKarger Kenneth · Graford, TXBuilt 2005 · S/N 3255031 N529RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1984 · S/N 60-8423004 N529SDReal Property Strategies LLC · Los Gatos, CABuilt 2007 · S/N T20608710 N52ACBloxham Tod · Tacoma, WABuilt 2011 · S/N T20609017 N52FBForslin Jeremy · Prior Lake, MNBuilt 1973 · S/N 61-0132-071 N52HFNorov Yury · Saint Augustine, FLBuilt 1964 · S/N 27-2568 N52JEAtkinson Holdings LLC · Kalispell, MTBuilt 1969 · S/N 61-0016 N52JKHigh Alpha LLC · Miami, FLBuilt 1979 · S/N 61P06367963292 N52MECopilots LLC · Ann Arbor, MIBuilt 2012 · S/N T20609062 N52TCVig Charles R · Prior Lake, MNBuilt 2000 · S/N 3257185 N53098Carlson Robert A Trustee · Rosamond, CABuilt 2003 · S/N T18208187 N530DCCrosswind Air LLC · Frederick, MDBuilt 2016 · S/N 4636690 N530JPScheibe Andreas Derek · Idaho Falls, IDBuilt 1991 · S/N 27-0114 N530MARice Solutions LLC · Farmington, NHBuilt 2023 · S/N 4636817 N531AMcs Aviation LLC · Wetumpka, ALBuilt 2000 · S/N 32-57160 N531ADP B J Equipment Rentals LLC · Watford City, NDBuilt 2021 · S/N T20609634 N531HPFlorida Highway Patrol · Tampa, FLBuilt 2001 · S/N T20608250 N531MZCassady Adam · Crestview, FLBuilt 2023 · S/N T20609733 N531PTViking Aviation LLC · Catoosa, OKS/N 3257280 N531SASpur Aviation Services Lc · Twin Falls, IDBuilt 1969 · S/N 3059 N53229Boos Michael R · Brandenburg, KYBuilt 2001 · S/N 3246188 N53266Jazzair LLC · Erie, COBuilt 2001 · S/N 3257233 N5327UJa Williams Investments LLC · Austin, TXBuilt 2003 · S/N T18208188 N5328ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257256 N53291North Country Aviation Service LLC · Lewes, DEBuilt 2007 · S/N T18208710 N532BZLicense2learn Aviation LLC · Port Orange, FLBuilt 2008 · S/N T20608818 N532DREllebracht Steve · Sedalia, MOBuilt 1998 · S/N 3257060 N532SJohnson Lucas G · Pleasant Lake, MIBuilt 1965 · S/N 27-2966 N532SA2flyshrike LLC · Miramar, FLBuilt 1969 · S/N 1868-44 N5330AGila Aviation LLC · San Luis, AZBuilt 2003 · S/N T18208190 N5330GKaris Aviation LLC · Poplar Bluff, MOBuilt 2001 · S/N 3257232 N5334KGlen Dale L · Ferndale, WABuilt 2003 · S/N T18208193 N533JTIpi Private Wealth LLC · Decatur, ILBuilt 2001 · S/N 3257198 N533SASpur Aviation Services Lc · Twin Falls, IDBuilt 1968 · S/N 1786-9 N533YABb Aero Works Ltd · Whitehouse, OHBuilt 1968 · S/N 31-157 N5341GRyno Works Inc · Mccall, IDBuilt 2003 · S/N T18208195 N5349HAviation Advisor Inc · Kenosha, WIBuilt 2003 · S/N T18208198 N5349MWhiskey Bravo LLC · Clarksville, TNBuilt 2002 · S/N 3257307 N53517Papadelta Inc Trustee · Wilmington, DEBuilt 2002 · S/N 4636330

Back to AD 71-13-01 R1