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.

N441MRHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2003 · S/N 1329 N441NCCharlie Papa LLC · Van Nuys, CABuilt 2005 · S/N 10621 N441PFBusy Bee Helicopters LLC · Dover, DEBuilt 2005 · S/N 1522 N441PRHuntingdon Valley Helicopter LLC · Wilmington, DEBuilt 2004 · S/N 10310 N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278 N441RHHobbs Jonnie L · Darnestown, MDBuilt 1997 · S/N 0401 N441SGChristmann Charles D · Patagonia, AZBuilt 2004 · S/N 10441 N441TBMansfield Heliflight Inc · Milton, VTBuilt 1999 · S/N 0631 N441THSchwarzenberg Johannes · Helena, MTBuilt 2004 · S/N 10334 N441WSFord Mark L · New Cambria, KSBuilt 1966 · S/N 670049 N44203Skyline Solutions Inc · Deland, FLBuilt 1974 · S/N 28-7415600 N4420JSilver Wings Aviation LLC · El Paso, TXBuilt 1967 · S/N 28-24067 N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167 N4420TElsner Wayne C · Plymouth, WIBuilt 1972 · S/N 28-7225169 N4420WOdonata LLC · Lewiston, IDBuilt 1974 · S/N P-268 N4420YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4040 N4420ZRuff Gregory Z · Red Bluff, CAS/N 18-8756 N44218Bluebird Aero LLC · Wilmington, DEBuilt 1974 · S/N 28-7415603 N4421DHolt Reginald M · Ankeny, IABuilt 2000 · S/N 22055 N4421JFirst Flight LLC · Caledonia, MIBuilt 1967 · S/N 28-22819 N4421PAmendt Joseph J Jr · Watertown, SDBuilt 1960 · S/N 23-1935 N4421TKinman Kary W · Panama City Beach, FLS/N 28-7225170 N4421XN4421x LLC · Sarasota, FLBuilt 1975 · S/N 28-7690007 N44228Christophersen Hunter R · Fairway, KSFirst renewal noticeBuilt 1974 · S/N 28-7405231 N44229Cabelka Jerry L · Glendale, AZBuilt 1974 · S/N 28R-7435301 N4422AHackwell Calvin · Enoch, UTBuilt 1956 · S/N 22-3751 N4422HWitherspoon Brian · Ben Lomond, CABuilt 1978 · S/N 24-0729 N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168 N4422TMooney22t LLC · Kalispell, MTS/N 305 N4422XKeys Andrew S · Harvest, ALBuilt 1975 · S/N 28R-7635038 N44236Tanner Rhett D Jr · Livingston, LABuilt 1974 · S/N 28-7425396 N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704 N4423RAviation Specialists Inc · Gonzales, LABuilt 1978 · S/N R18200597 N4423XShiloh Aircraft Museum Inc · Wilmington, DEBuilt 1975 · S/N 28-7610017 N44245Riter Robert M · Hereford, AZBuilt 1974 · S/N 28-7425397 N4424AHulme Randi M · Kimberly, IDBuilt 1956 · S/N 22-3753 N4424JSeaplane Adventures LLC · Cheyenne, WYBuilt 1967 · S/N 28-22824 N4424RBazemore Bryan P · Charlotte, NCBuilt 1978 · S/N R18200598 N4424TKoplin Adam · Big Stone City, SDBuilt 1972 · S/N 28R-7235046 N4424ZChmiel John E · Rhinelander, WIFirst renewal noticeBuilt 1969 · S/N 18-8761 N44253Bull Kenneth · Dania Beach, FLBuilt 1974 · S/N 28-7415610 N44254Bridges D Scott · Paducah, KYBuilt 1974 · S/N 28R-7435304 N4425JReynolds Darryl G · Wills Point, TXBuilt 1967 · S/N 28-22825 N4425TBooth Aviation LLC · Fort Worth, TXS/N 32-7240080 N4425ZSale Reported · Quincy, WASale reportedBuilt 1968 · S/N 18-8762 N44267Ethridge Mark Lance · Allen, TXBuilt 1974 · S/N 28-7415611 N4426AShankle Matthew B · Culpeper, VAS/N 22-3755 N4426JScott Robirt L · Independence, IAS/N 28-22828 N4426THershberger Randall J · Coventry, CTBuilt 1972 · S/N 28-7105232 N4426YR & S Enterprises · Fort Wayne, INBuilt 1971 · S/N 27-4708

Back to AD 87-10-06 R1