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.

N6239APara Plane Aviation Inc · Thomasboro, ILS/N 33039 N6239DAerial Precision LLC · Entiat, WAS/N 17272657 N6239EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1958 · S/N 46339 N6239FEckert Ted · Cedar Creek, TXBuilt 1979 · S/N 17273172 N6239RBala Engineering Pllc · Hawkins, TXBuilt 1965 · S/N 15061539 N6239TEvans Cliff D · Boulder Creek, CAS/N 15060939 N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304 N623AFFleetshares N623af Inc · Lincoln, NES/N 15280841 N623APHartman Michael F · Montclair, CABuilt 1969 · S/N 15070915 N623EPApex Aviation LLC · Exeter, NHBuilt 1975 · S/N 18052616 N623PADsr Cherokee 180 LLC · Dallas, TXBuilt 1985 · S/N 15286002 N623WTChasteen Tom · Tavernier, FLBuilt 1963 · S/N 205-0328 N62400Henline Matthew · Honolulu, HIBuilt 1972 · S/N 18261290 N62405Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17275263 N62407Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275264 N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718 N6240EDgcg Properties LLC · Casa Grande, AZBuilt 1959 · S/N 46340 N6241AAerial Messages Leasing Co · Longwood, FLBuilt 1956 · S/N 33041 N6241ERuijne Leo L · Plainview, TXS/N 46341 N6241FBucks Mont Masonry Inc · Green Lane, PABuilt 1975 · S/N 18264141 N6241NSt Croix Recreation LLC · Mulberry, FLS/N 18267807 N6241RHayhurst Shane R · Winfield, PABuilt 1965 · S/N 15061541 N6241TArm 4 Aviation LLC · Blanchard, IABuilt 1964 · S/N 15060941 N62425Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 17275267 N62429Fowler Cary D · Hayti, MOBuilt 1981 · S/N 17275268 N6242EDenson Randy A · Meridian, IDBuilt 1958 · S/N 46342 N6242GSpencer Aviation Inc · Delaware, OHBuilt 1970 · S/N 15071742 N6242THuff Glenn R · Garrison, MNBuilt 1964 · S/N 15060942 N6243AKolar James P · Mendota Heights, MNBuilt 1956 · S/N 33043 N6243CDcd Aircraft Sales LLC · Leesburg, FLS/N 21063841 N6243FReim Rodney D · Enid, OKBuilt 1965 · S/N 337-0243 N6243GRed Oak Commuter LLC · Red Oak, IABuilt 1970 · S/N 15071743 N6243KAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N R1722036 N6243QHanzawa George K · Honolulu, HIBuilt 1981 · S/N 15285208 N6243SBlackwood Heath · Meridian, IDBuilt 1967 · S/N 15067043 N6243TStanek Michael K · Palm Bay, FLBuilt 1964 · S/N 15060943 N6243ZSeattle Seaplanes LLC · Seattle, WABuilt 1981 · S/N U20606199 N62444Ditmer Jack L Jr · Troy, OHBuilt 1981 · S/N 17275271 N62447Tri-State Flg Club Inc · Huntington, WVBuilt 1981 · S/N 17275272 N6244ASioholm William N Jr · Wallingford, CTFirst renewal noticeBuilt 1956 · S/N 33044 N6244ESpicer Aaron D · Wadena, MNBuilt 1958 · S/N 46344 N6244FRegistered aircraftBuilt 1965 · S/N 337-0244 N6244RWright Skye R · Quitman, ARBuilt 1965 · S/N 15061544 N6244TAljanabi Mohammed K · Herndon, VABuilt 1964 · S/N 15060944 N62457Pisarello William J · Sebring, FLBuilt 1981 · S/N 17275275 N6245ABackcountry Guys LLC · Prescott, AZBuilt 1956 · S/N 33045 N6245DJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17272661 N6245FCosse Harold C · Euless, TXS/N 337-0245 N6245GCulpepper Christopher H · Harper, TXS/N 15071745 N6245SFillmore Aviation LLC · South Saint Paul, MNBuilt 1980 · S/N R18201653

Back to AD 87-20-03 R2