Registered aircraft · 72,001

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N1483CWang Helin · Dana Point, CABuilt 2005 · S/N T18208419 N1483JMcmillan Gavin · Tarpon Springs, FLBuilt 1977 · S/N 542 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484JGingles Collie Jr · Mint Hill, NCBuilt 1976 · S/N 484 N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485CLiebowitz Alan · Sioux Falls, SDBuilt 2005 · S/N T18208421 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148 N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N148DHLeclerc Robert L · Olympia, WABuilt 1994 · S/N 3082 N148DPHenke Kristen C · Bettendorf, IAS/N 11015C N148FRamsey William · Eagan, MNBuilt 2000 · S/N 6035 N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148GHLattimore Partners LLC · Fort Worth, TXBuilt 2005 · S/N T18208417 N148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 2020 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148LMMoore Shelby L · Mount Pleasant, NCBuilt 2005 · S/N 5494 N148MHSmith Timothy Landon · Jonesville, NCBuilt 2017 · S/N 22570 N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005 N148PSAsplundh Wayne B · Philadelphia, PABuilt 2001 · S/N 6048 N148RFPaklook Air Inc · Bethel, AKFirst renewal noticeBuilt 1976 · S/N 32R-7680076 N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008 N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148 N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040 N148TABusiness Revenue Corp · Newton, IABuilt 1998 · S/N 6014 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282 N1490XTwin Peaks Holdings · Midvale, UTBuilt 1975 · S/N 28-7510095 N1491PSale Reported · Oklahoma City, OKSale reportedBuilt 1956 · S/N 23-561

Back to AD 87-10-06 R1