Registered aircraft · 72,010

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.

N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811 N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881 N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206 N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176 N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026 N45077Qualitair LLC Owner Trustee · MichelstadtBuilt 1978 · S/N 28-7911291 N4507JSkvara Stanley Henry Jr · Parma, OHBuilt 1968 · S/N 28R-30363 N4507LAntique Preservation Associationof Greenfield · Greenfield, IABuilt 1973 · S/N 006 N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031 N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032 N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246 N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174 N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046 N4507YEmanuels Adam C · Selma, NCBuilt 1979 · S/N 28-7911290 N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813 N4508JWood Daniel W · Cottonwood Shores, TXBuilt 1968 · S/N 28R-30364 N4508RMcmichael Timothy J · Rock Hill, SCBuilt 1979 · S/N 32-7940245 N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026 N4509HGolding Lee · Brookline, MOBuilt 1978 · S/N 24-0753 N4509XPerformance Power Services Pc · Naperville, ILBuilt 1975 · S/N 28R-7635067 N4509YWolfrum John A · Two Rivers, AKBuilt 1971 · S/N 18-8930 N450AACentex Aero LLC Trustee · San Antonio, TXBuilt 2019 · S/N 2881256 N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123 N450BASimmons Brian R · Heavener, OKBuilt 1981 · S/N M-2342 N450CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881122 N450DLBay Larry · San Diego, CABuilt 2003 · S/N 10236 N450FLMorriss Aviation LLC · Allen, TXBuilt 1971 · S/N 28-7125243 N450JAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496150 N450JDJd Dakota Leasing LLC · Stuart, FLBuilt 1978 · S/N 28-7911017 N450KCCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 31-7852092 N450KSGreene Tammy G · Alpharetta, GAS/N 1978 N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206 N450RBurns Richard · Wasilla, AKBuilt 2003 · S/N 450R N450RSMcpherson Norman B · Woodland Park, COBuilt 2009 · S/N 60425 N450VVCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496113 N450WMArbuthnot Michael D · Pagosa Springs, COBuilt 1996 · S/N 3125 N450ZRCasey William · Celina, TXBuilt 2021 · S/N 2881481 N4510AGarvey James R · Fairhope, PABuilt 1956 · S/N 22-3815 N4510DCamwhit Air Corp · Montgomery, NYBuilt 1979 · S/N 28-8016015 N4510RMcmichael Steven G · Eden, NCBuilt 1979 · S/N 28-8090036 N4510YFrost John David Trustee · Anchorage, AKBuilt 1972 · S/N 18-8931 N45110Bluebeck Ltd · East Norwich, NYBuilt 1979 · S/N 28-7911294 N4511BGcbc LLC · Norman, OKBuilt 1979 · S/N 28-8090037 N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619 N4511HVeritas Urbis Economics LLC · Groveland, CABuilt 1978 · S/N 24-0755 N4511JNoyes Tony · Lewisville, TXS/N 28R-30367 N4511VOraz Aviation LLC · Oregon City, ORBuilt 1979 · S/N 28-7911293 N4511YWab Air LLC · Boulder, MTBuilt 1971 · S/N 18-8932 N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016 N4512RElder Abuse Air Force · Rcho Sta Marg, CAS/N 28-21213

Back to AD 87-10-06 R1