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.

N4826WRoss Steve M · Marion, ILBuilt 1976 · S/N 14156 N482CGKilo Sierra Enterprises LLC · Lafayette, COBuilt 2005 · S/N T18208438 N482DRThurston Steven Curtis · Salisbury, NCBuilt 1977 · S/N 32R-7780391 N482RPPlane Robert A · Harvard, ILBuilt 1976 · S/N 14155 N482STJ & M Holdco LLC · Cookeville, TNBuilt 2008 · S/N 3257482 N4830WCaliguire Michael R · Easton, PABuilt 1976 · S/N 14160 N4832WDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14162 N4837WFields Joseph H · Placerville, CABuilt 1976 · S/N 14167 N4839TOrchard Elms LLC · North Ogden, UTBuilt 2011 · S/N T18209026 N483CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T18209172 N4843WMcclean Matthew James · Springfield, MOBuilt 1976 · S/N 14173 N4845FMattern Jeffrey A · Brunswick, OHBuilt 1976 · S/N 32R-7680482 N4846WPrice David · Loudon, TNS/N 14176 N4847WIskin Jeffrey Trustee · Concord, CABuilt 1976 · S/N 14177 N484APDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 32-8124003 N484CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T20609802 N484HRCebolla Air LLC · Camarillo, CABuilt 2009 · S/N T18208973 N4850WWilliams Edward · Hayward, CABuilt 1976 · S/N 14180 N4851FRagland Brady J · Amarillo, TXBuilt 1976 · S/N 32R-7680483 N4855PAvenger Aviation LLC · Midland, TXBuilt 2004 · S/N T18208337 N4856WUhl John W · Sellersburg, INBuilt 1976 · S/N 14186 N4857WShelor Christina L · Virginia Beach, VABuilt 1976 · S/N 14187 N4869BSchaffer Brandon T · Vlg Of Lakewd, ILBuilt 1984 · S/N 32-8424002 N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054 N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057 N488ATParks Vernon L · Houston, TXBuilt 1991 · S/N 27-0088 N488EAChristopher Jason Lee · Morgan Hill, CABuilt 2008 · S/N 4692016 N4892SF&G Polk Aviation LLC · Babson Park, FLBuilt 1971 · S/N 32-7140058 N4895WTaylor Mark W · Amherst, NYBuilt 1977 · S/N 14225 N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227 N489CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T20609801 N48HCMirage Flight LLC · Kalispell, MTS/N 4636377 N48TNWest Thomas L · Payson, AZBuilt 1975 · S/N 60-0214-094 N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022 N4911W3js Aviation LLC · Wilmington, DEBuilt 1977 · S/N 14235 N491JGHartwig Farms LLC · Excelsior Springs, MOBuilt 2001 · S/N T20608265 N4921WForward Aero LLC · Thomasville, PABuilt 1977 · S/N 14245 N4927FRegistered aircraftBuilt 1976 · S/N 32R-7680489 N4928WL D Aviation LLC · Chesapeake, VABuilt 1977 · S/N 14251 N492AGBounds Lee S · Pflugerville, TXS/N 32-40228 N492BCConsumer Collection Management Inc · Saint Louis, MOBuilt 2005 · S/N 3255037 N492TBTrux Aviation LLC · Wilmington, DEBuilt 2006 · S/N T18208505 N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254 N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256 N4942FBarton Investment LLC · Salt Lake City, UTBuilt 1976 · S/N 32R-7680490 N4947FKpw Enterprises Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680492 N494MBMulhearn Walter F · Conroe, TXBuilt 1980 · S/N 32R-8029056 N494SMSurveying And Mapping LLC · Austin, TXBuilt 2022 · S/N T20609674 N495BJObr Leasing · Bristow, VABuilt 2010 · S/N T20608963 N495JBVan Bortel Aircraft Inc · Arlington, TXBuilt 2004 · S/N T18208284

Back to AD 71-13-01 R1