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.

N7895FBrock Michael G · New Lenox, ILBuilt 1966 · S/N 15063995 N7895VCleared For Takeoff LLC · Katonah, NYBuilt 1976 · S/N 177RG0913 N7895XVerhalen John P Jr · Scottsville, TXBuilt 1961 · S/N 17248395 N7896SPanepinto Lane · Lafitte, LABuilt 1967 · S/N U2060814 N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796 N7897FOneonone Flight Training LLC · Hagerstown, MDBuilt 1966 · S/N 15063997 N7897TFunk Kenneth E · Warner Robins, GABuilt 1960 · S/N 47497 N7897UFischer Duane A · New Baden, ILBuilt 1964 · S/N 17251897 N7898GMccutcheon Frank Jr · Scottsboro, ALBuilt 1970 · S/N 17259598 N7899NUnited States Air Force Owner · Colorado Springs, COBuilt 1968 · S/N R172-0290 N7899UDeidiker Floyd D · West Plains, MOBuilt 1964 · S/N 17251899 N7899XHines Jairus B · Lenoir City, TNBuilt 1961 · S/N 17248399 N7899ZJsh Farms Inc · Wapato, WABuilt 1963 · S/N 15059999 N789CEBond Brent L · Clearwater, KSBuilt 1978 · S/N 17270536 N789DMAllen Gary D · Eyota, MNS/N 18266555 N789GTJj Hughes Logistics LLC · Canyon, TXS/N R18200561 N789NTjb Ent LLC · Spokane, WABuilt 1982 · S/N 18504390 N789RAMiller Melanie L · Spanaway, WABuilt 1976 · S/N 17267184 N789SSummit Aircraft LLC · Seattle, WABuilt 1963 · S/N 17250862 N789ZParish Charles L · Tullahoma, TNBuilt 1978 · S/N 18503644 N78BLLaukka Bruce L · West Rockport, MEBuilt 1977 · S/N 18503324 N78DEStanley Ryan G · Mossyrock, WAS/N 18503701 N78ERFreeway Airport Inc · Mitchellville, MDBuilt 1983 · S/N 17276003 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N78FGMcclanahan John B · Fayetteville, GAS/N 18255224 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78LHL & J Adventures LLC · Paris, OHBuilt 1978 · S/N 18266426 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N78PCBombach James · Katy, TXBuilt 1976 · S/N 18264893 N78RGBubber Inc · Lake Providence, LABuilt 1977 · S/N R18200057 N78RRWilkinson William H · Anchorage, AKBuilt 1973 · S/N 18261689 N78SMZimmerman Gregory J · Iowa City, IABuilt 1968 · S/N 337-1046 N78WRSwift Aviation LLC · Lampasas, TXBuilt 1977 · S/N 18265385 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N79000Kemmis Sidney C · Prophetstown, ILBuilt 1968 · S/N 17257797 N79001Pau Hana Enterprises LLC Series IV · Boulder City, NVBuilt 1968 · S/N 17257798 N79002Fremont Aviation Inc · Fremont, NES/N 17257799 N79004Palmer Joe A · Meridian, IDBuilt 1968 · S/N 17257801 N79009Birkholz Raymond J · Boulder, COBuilt 1968 · S/N 17257806 N7900FValley Wine Exports LLC · Rollingbay, WABuilt 1966 · S/N 15064000 N7900GGreat Plains Enterprises LLC · Wilmington, OHBuilt 1970 · S/N 17259600 N7900NWarren County Sheriffs Dept · Mcminnville, TNBuilt 1968 · S/N R172-0291 N7900UJames Timothy C · Morehead, KYBuilt 1964 · S/N 17251900 N7900ZWebber Jerry D · Cleburne, TXBuilt 1963 · S/N 15060000 N79012Brewer Jeremiah L · Eagle River, AKBuilt 1968 · S/N 17257809 N79013Woods Michael F · Hamilton, NJBuilt 1968 · S/N 17257810 N79014Fcs Aviation LLC · Lewisport, KYBuilt 1968 · S/N 17257811 N79015Flying Weaners Inc · Jacksonville, FLBuilt 1968 · S/N 17257812 N7901BCantrell Dennis · Conway, ARBuilt 1957 · S/N 29701

Back to AD 87-20-03 R2