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.

N3621UStewart Gary T · Friendswood, TXBuilt 1963 · S/N 18255021 N3621YRegistered aircraftBuilt 1963 · S/N 21058121 N3622LStrelzik Raymond W · Hatfield, PABuilt 1965 · S/N 17253791 N3622SMichael Lewis R · Big Rapids, MIS/N 17250822 N3622UDegonia Gerald · Plainfield, ILBuilt 1963 · S/N 18255022 N3622VFox John E · Boonville, CABuilt 1975 · S/N 15076565 N3623VClark Cecil L · Shreveport, LABuilt 1975 · S/N 15076566 N3624CMeadows Marcus M · Anchorage, AKBuilt 1954 · S/N 31122 N3624UWilkinson Larry G · Henderson, NVBuilt 1963 · S/N 18255024 N3625CBurton Michael A · Chicago, ILBuilt 1978 · S/N R18200283 N3625LWilliams Michael R · Gig Harbor, WABuilt 1965 · S/N 17253794 N3626CCowey Kevin M · Pittsburgh, PABuilt 1978 · S/N R18200284 N3626JEa Cvg LLC · Erlanger, KYS/N 15064926 N3626LKoshar Robert E · Watervliet, MIBuilt 1965 · S/N 17253795 N3626VTorres Torres Angel G · Chesapeake, VABuilt 1975 · S/N 15076567 N3626YNb Ag Solutions Inc · Manila, ARBuilt 1963 · S/N 21058126 N3627CWebb Brent · Safford, AZBuilt 1978 · S/N R18200285 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N3627LGeorge Edward J · Highland Village, TXBuilt 1965 · S/N 17253796 N3627UStribling Tyron S · Lagrange, GABuilt 1963 · S/N 18255027 N3627YBarber Michael · Pagosa Springs, COS/N 21058127 N3628JLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15064928 N3628LThrasher Gary Phillip · Galena, OHBuilt 1965 · S/N 17253797 N3628SWright Way Air Venture LLC · Westville, INBuilt 1963 · S/N 17250828 N3629SBradley Christopher J · Left Hand, WVBuilt 1963 · S/N 17250829 N362BCWing Nutz LLC · Redondo Beach, CABuilt 1979 · S/N R18201365 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362KWFliteco Holdings LLC · Lewes, DES/N 18260338 N362LKJackson Brian J · Anchorage, AKS/N 15076026 N362PC362 Papa Charlie LLC · Spokane, WABuilt 1972 · S/N 18261242 N3630SFly Dogs LLC · Sunbury, OHBuilt 1963 · S/N 17250830 N3631CClark Mark R · Pullman, WABuilt 1954 · S/N 31129 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3631LMcveigh Ian T · Mansfield, TXS/N 17253800 N3631SJust Plane Fun 9m6 LLC · Lake Providence, LABuilt 1963 · S/N 17250831 N3631UBurden Richard M · Woodway, TXBuilt 1963 · S/N 18255031 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N3632JMitterling Richard H · Boothbay Harbor, MEBuilt 1966 · S/N 15064932 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3633JMicrokit Solutions LLC · Bridgeview, ILS/N 15064933 N3633UBrasher Cecil V Jr · Jamestown, NCBuilt 1963 · S/N 18255033 N3634JLuft Inc · North Fort Myers, FLBuilt 1966 · S/N 15064934 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803 N3635CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 31133 N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3635VTz Airways 1 LLC · Avon Park, FLBuilt 1975 · S/N 15076570 N36362Sale Reported · WitshireSale reported, pending cancellationBuilt 1955 · S/N 31691 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3636SGriesman Scott W · Sandy Valley, NVBuilt 1963 · S/N 17250836

Back to AD 87-20-03 R2