Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106 N6706SDavis Bradley · Oconomowoc, WIBuilt 1967 · S/N 15067506 N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548 N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107 N6708GRussell Gary W · Martinsburg, WVBuilt 1970 · S/N 15072208 N6708MPrecision Aviation Inc · Kimberly, IDBuilt 1975 · S/N 18263809 N6709AEvanoff Aaron · Fowlerville, MIFirst renewal noticeS/N 28809 N6709EDixon Kevin S · Shady Shores, TXS/N 56209 N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489 N6710GShelton Dale E · West Frankfort, ILBuilt 1970 · S/N 15072210 N6710MFlying Skylanes Inc · Hillsborough, CABuilt 1975 · S/N 18263810 N6711AAero Club Valkaria LLC · Malabar, FLBuilt 1956 · S/N 28811 N6711EGardner Terrence L · Pittsboro, NCS/N 56211 N6712EEdwards Joseph C · Austin, ARBuilt 1959 · S/N 56212 N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112 N6712SDunaire LLC · Mechanicsburg, PABuilt 1967 · S/N 15067512 N6713CClemens Jerry W · Benton, KSBuilt 1965 · S/N 18256662 N6713ECendejas Agustin · Chino, CAS/N 56213 N6714APelcher Devin · Ormond Beach, FLBuilt 1956 · S/N 28814 N6714MIda Aviation LLC · Virginia Beach, VABuilt 1975 · S/N 18263812 N6715GCardwell Aubrey Lynn · Spring Branch, TXBuilt 1970 · S/N 15072215 N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115 N6717AHeffron Jacob L · Little Falls, MNBuilt 1956 · S/N 28817 N6717EDenrow Limited Lc · Shawnee, OKBuilt 1978 · S/N 17272055 N6717GJet Airways Express Inc · Aventura, FLS/N 15072217 N6718AWolfe Quest M · Phoenix, AZBuilt 1956 · S/N 28818 N6718SRoberts Brandon R · Bogata, TXBuilt 1967 · S/N 15067518 N6719ASantana Maria De La Luz · Hemet, CAS/N 28819 N6719EOleary Aviation Inc · Sibley, IABuilt 1959 · S/N 56219 N671HABartek Ronald · Lake Charles, LAS/N 15076505 N671PMBarron Bradley C · Harper, TXBuilt 1979 · S/N 18267475 N671VHRobert And Andrea Van Hofwegen LLC · Buckeye, AZBuilt 1956 · S/N 29459 N6720AFremgen Stephen M · Carrollton, TXBuilt 1956 · S/N 28820 N6720ESegerstrom Ricky G · Grandview, TXS/N 56220 N6720GMcclintick Marshall Wyatt · Daniel Island, SCBuilt 1970 · S/N 15072220 N6720RJacobsen Ian M · Lincoln City, ORBuilt 1966 · S/N T210-0120 N6720SWilliams Kenneth J · Hampton, NYBuilt 1967 · S/N 15067520 N6721ARogers Jeffery D · Franklin, WIS/N 28821 N6721ESonoma Valley Aircraft Inc · Vineburg, CABuilt 1959 · S/N 56221 N6721SRenwick Stephen P · Moss Beach, CABuilt 1967 · S/N 15067521 N6722BJca Aviation LLC · Safford, AZS/N 21062826 N6722GPiasa Flyers Inc · East Alton, ILBuilt 1970 · S/N 15072222 N6722MLatham Scott W · Naples, FLBuilt 1975 · S/N 18263815 N6722SCampbell J Tyler · Chestertown, MDBuilt 1967 · S/N 15067522 N67236Cessna N67236 LLC · Harrah, OKBuilt 1964 · S/N 18255666 N6723GPressley Brandon S · York, SCBuilt 1970 · S/N 15072223 N6724AGodin George A · Franklin, VTBuilt 1956 · S/N 28824 N6724RDavis Lease LLC · Fort Collins, COBuilt 1966 · S/N T210-0124 N6725ESocal Jet Services Inc · Long Beach, CABuilt 1959 · S/N 56225 N6725FReberry Brian Keith · Boise, IDBuilt 1966 · S/N 15063325

Back to AD 87-20-03 R2