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.

N65525Sinha Nanda K · Benicia, CABuilt 1982 · S/N 17275774 N65528Jacks Charles D · Crowley, LABuilt 1983 · S/N 17275775 N6552BHollenberg Randall W · Houston, TXBuilt 1979 · S/N 15283948 N6552FAir Planes LLC · Soddy Daisy, TNBuilt 1979 · S/N 17273239 N6552MLanman Inc · Litchfield, ILS/N 18263750 N6553DLlv Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272861 N6553EZa Airport Rental LLC · Zanesville, OHBuilt 1978 · S/N 17272037 N6553KSchaffner Christopher · Dunmore, WVBuilt 1980 · S/N 17274211 N6553SRegistration Pending · Coeur D Alene, IDRegistration pendingBuilt 1967 · S/N 15067353 N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434 N65546Baas Holdings LLC · Lewes, DES/N 15281608 N6554DHancock Jeffrey D · Delta, COBuilt 1979 · S/N 17272862 N6554FMendonca Jimmy · Caddo Mills, TXBuilt 1966 · S/N 15063154 N6554GAll Bid Inc · Opelousas, LAS/N 15072054 N6554LN6554l LLC · Cheyenne, WYBuilt 1980 · S/N 15284432 N65550Haltom Gary D · Alva, OKBuilt 1978 · S/N 15281612 N65551Riverside Flight Center Inc · Tulsa, OKBuilt 1978 · S/N 15281613 N6555ADensmore James E Jr · Colorado Springs, COBuilt 1956 · S/N 32452 N6555FThompson Jeffrey L · Scandia, KSS/N 15063155 N6555JTeton Leasing LLC · Pocatello, IDBuilt 1980 · S/N 17273890 N6555XViera Fernando Jr · Asbury, MOBuilt 1960 · S/N 57555 N6555YMild Charles F · Harlingen, TXBuilt 1981 · S/N 21064436 N65561Wisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 15281619 N65563Darcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 15281621 N6556GBurnett Gregory D · Union, KYBuilt 1970 · S/N 15072056 N6556HRyco LLC · Lusk, WYBuilt 1975 · S/N 17265486 N6556SPflederer Raymond F · Sturgeon Bay, WIBuilt 1967 · S/N 15067356 N65572Rucinski Edward A · Climax, NCS/N 15281626 N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786 N6557EClor Rosalee G · Saint Clair, MIS/N 56057 N6557HRiverside Flight Academy LLC · Riverside, CABuilt 1975 · S/N 17265487 N6557MHenderson Douglas A · Cape Coral, FLBuilt 1975 · S/N 18263753 N6557XYarnell Bruce W · Stockton, MOBuilt 1960 · S/N 57557 N65582Curley Keron P · Rockaway Park, NYBuilt 1978 · S/N 15281632 N65583Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281633 N65584G And M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281634 N65586Sunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N 15281636 N65587Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275780 N6558FMolek Jon · Warren, OHS/N 15063158 N6558SVan Bavel Ethan G · Soldotna, AKBuilt 1967 · S/N 15067358 N65592Cohen Frederick I Trustee · Tulsa, OKBuilt 1978 · S/N 15281639 N6559ECarlson Garrett R · Ramsey, MNS/N 56059 N6559SReichelt Harvey R · Ossian, INBuilt 1967 · S/N 15067359 N655CFCarter James W · Dyersburg, TNBuilt 1964 · S/N 337-0016 N655SWIverson Michael D · Lino Lakes, MNBuilt 1955 · S/N 31887 N655WBGrecor LLC · Ashville, ALBuilt 1955 · S/N 31908 N65609Leland Robert · Ft Wayne, INBuilt 1978 · S/N 15281648 N6560AN6560a LLC · Saint Albans, MEBuilt 1956 · S/N 32457 N6560EAeschliman Arlie W · Tribune, KSBuilt 1959 · S/N 56060 N6560MCopich John J · Youngstown, OHBuilt 1975 · S/N 18263754

Back to AD 87-20-03 R2