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.

N3589FInmon Glen A · Pontotoc, MSBuilt 1966 · S/N 18257589 N3589LSale Reported · Bloomburg, TXSale reportedBuilt 1965 · S/N 15062389 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N3589SErickson Miles · Langley, WABuilt 1963 · S/N 17250789 N3589YHmb Aviation LLC · St George, UTS/N 18254489 N358KSForgues Inc · Wilmington, DEBuilt 1967 · S/N 15066671 N358TACrow Edward N · Silverdale, WABuilt 1959 · S/N 46666 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792 N3590CZwingmann Ken · Whittier, CABuilt 1955 · S/N 26634 N3590JLutes Robert Trustee · New Paris, INBuilt 1965 · S/N 15061290 N3590SNorthwest Aircraft Services LLC · Hayden, IDS/N 17250790 N3590YAlexander Macy Nix · Mineral Wells, TXBuilt 1963 · S/N 18254490 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N3591CSchlender Michael E · Clintonville, WIBuilt 1955 · S/N 26635 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591SPitt Kenneth · Paonia, COBuilt 1963 · S/N 17250791 N3592FArey Peter W · Great Falls, VABuilt 1966 · S/N 18257592 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692 N3592YArcher Donald B · Artesia, NMBuilt 1962 · S/N 18254492 N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693 N3593UBdg Holdings Inc · Kingston, PABuilt 1969 · S/N 18259866 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819 N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821 N3594CNichols Jamie · Naples, MEBuilt 1955 · S/N 26638 N3594FFirst Flight Corp · San Diego, CABuilt 1966 · S/N 18257594 N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694 N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825 N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829 N3595JSchroeder Glenda P · Evansville, INBuilt 1965 · S/N 15061295 N3595SBarnett Carl Chris · Todd, PABuilt 1963 · S/N 17250795 N3595UBrinkman Eric · Phoenix, AZBuilt 1963 · S/N 18254995 N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833 N3596JOld Trail Inc · Baker City, ORS/N 15061296 N3596YHeintz Ludwig C · Covington, LABuilt 1962 · S/N 18254496 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601 N3597FLivesay John · Pana, ILBuilt 1966 · S/N 18257597 N3597SHawkins Ronald Lee · Vancouver, WABuilt 1963 · S/N 17250797 N3597VMcleod Patrick J · Overgaard, AZBuilt 1975 · S/N 15076557 N3597YCraig & Craig LLC · Merrillville, INS/N 18254497 N3598CN3598c LLC · Ellisville, MOBuilt 1955 · S/N 26642 N3598JMclaughlin George F · Kennesaw, GABuilt 1965 · S/N 15061298

Back to AD 87-20-03 R2