Registered aircraft · 54,017

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.

N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268 N4943EPettit Robert · Carnegie, OKS/N 18503914 N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N4944DSelkirk Associates Inc · Wilmington, DEBuilt 1958 · S/N 51044 N4944PReed John Richard · Charleston, ILBuilt 1964 · S/N 18255703 N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461T N4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N4945AIverson Randy · Winnemucca, NVBuilt 1956 · S/N 32342 N4945TBj Aviation Inc · Littleton, COS/N R18201800 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeBuilt 1979 · S/N 18503916 N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378 N49470Stidsen Carlton A · Tolland, CTS/N 15281293 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N4947AGleiter David W · Overland Park, KSBuilt 1956 · S/N 32344 N4947DEnstrom Thomas · New Berlin, NYBuilt 1958 · S/N 51047 N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494 N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682T N4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486 N4948CRobillard Ross · Eveleth, MNBuilt 1975 · S/N 18502664 N4948DSobrado Victor M · Norman, OKBuilt 1958 · S/N 51048 N4948GTrece Inc · Adair, OKS/N 17273495 N4948QWhite Ronald A · Anchorage, AKBuilt 1978 · S/N 18503583 N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465 N4948STaildragon LLC · Albuquerque, NMBuilt 1980 · S/N R18201487 N4948URegistered aircraftBuilt 1965 · S/N 21058648 N4949CHatchie River Aviation LLC · Kalispell, MTBuilt 1982 · S/N T30300128 N4949ETrans Crafts LLC · Big Lake, AKBuilt 1979 · S/N 18503917 N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496 N4949NCompass Rose Aviation · Derby, KSBuilt 1979 · S/N 18267474 N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466T N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969 N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156 N494RAAstra Integrated Technologies LLC · Rockledge, FLBuilt 1967 · S/N 15066996 N494TMDuke Flight Training LLC · Bonnyman, KYBuilt 1975 · S/N 17265022 N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201 N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129 N4950AShaffer Barbara J · Franklin, KYS/N A1520910 N4950DSimpson Darrell W · Soldotna, AKBuilt 1979 · S/N 17272408 N4950HVaivadas Brian S · Bonney Lake, WABuilt 1981 · S/N 18267856 N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810 N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174 N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055 N49516Bresson Flying Service Inc · Compton, ILBuilt 1979 · S/N 15283467 N4951A152 University LLC · Blacksburg, VABuilt 1979 · S/N A1520911 N4951BTaylor Randall G · Pottstown, PAFirst renewal noticeBuilt 1979 · S/N 15283719 N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651

Back to AD 87-20-03 R2