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.

N7600TXin Han Aviation LLC · Atwater, CABuilt 1960 · S/N 47200 N7600VRegistration Pending · Phillipsburg, KSRegistration pendingBuilt 1976 · S/N 177RG0886 N7600XDemurat Bryan F · Casselberry, FLBuilt 1960 · S/N 17248100 N76015Aldea Aviation Partners LLC · Encino, CABuilt 1976 · S/N 17268091 N76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeBuilt 1976 · S/N 17268092 N76019Grimley Robert J · Palermo, NJS/N 17268093 N7601ACranor Clayton · North Pole, AKS/N 32498 N7601GWright Carl E · Conesville, OHS/N 17259301 N7602GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259302 N7602SLarson Peter M Trustee · Antioch, ILBuilt 1976 · S/N 18265250 N7602TColeman David R · Limerick, MEBuilt 1959 · S/N 47202 N7602XBurkett Anthony E · Rock Hill, SCS/N 17248102 N76032Brown Jeffrey A · Wellington, ALBuilt 1976 · S/N 17268097 N7603ANoble Raymond D · East Windsor, CTBuilt 1956 · S/N 32500 N7603GFelstead R Keith Trustee · Medina, NYBuilt 1970 · S/N 17259303 N7603SBobcat Trucking Inc · New Braunfels, TXBuilt 1976 · S/N 18265251 N7603TMurphy Brian K · La Crosse, WIFirst renewal noticeS/N 47203 N7603XHanson Scott E · Auburn, CABuilt 1977 · S/N R18200112 N76044Williams Cecil R · Clarksville, TNBuilt 1976 · S/N 17268101 N76047Registration Pending · Muskogee, OKRegistration pendingBuilt 1976 · S/N 17268103 N7604FKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1979 · S/N 17273262 N7604MVaughn David Rex · Spur, TXBuilt 1959 · S/N 55904 N7604SCloud Nine Management LLC · Orlando, FLBuilt 1976 · S/N 18265252 N7604TWestern Nebraska Technical College · Scottsbluff, NEBuilt 1960 · S/N 47204 N7604UWings Flight Enterprises Inc · Danville, KYBuilt 1975 · S/N 15077766 N76053Ape LLC · Birmingham, ALBuilt 1976 · S/N 17268106 N76056Bormuth Alan R · Morganton, NCBuilt 1976 · S/N 17268108 N7605FPromise Road Aviation Inc · Pendleton, INBuilt 1979 · S/N 17273263 N7605SAdco Land Corp · Richmond, VABuilt 1976 · S/N 18265253 N7605URyan Air Inc · Anchorage, AKBuilt 1978 · S/N 20700443 N7605XCastleberry Robert F · Sanford, NCS/N 17248105 N7606MDellechaie Frank · South Lake Tahoe, CABuilt 1959 · S/N 55906 N7606SAnthony Judith A Trustee · Kerrville, TXBuilt 1976 · S/N 18265254 N7606TFord Edsel W · Mustang, OKBuilt 1959 · S/N 47206 N7606VDahdah Kurt J · Agawam, MABuilt 1977 · S/N R1722311 N7606XRegistered aircraftS/N 17248106 N76076Elite Airplanes LLC · Fort Myers, FLS/N 17268114 N7607EPowerbelt LLC · Glendale, CABuilt 1978 · S/N 17272115 N7607FRolinski Alexander S · Deland, FLBuilt 1979 · S/N 17273265 N7607GOwens Wilbur · Rch Palos Vrd, CAS/N 17259307 N7607LMeyer Maria S · New Fairfield, CTBuilt 1978 · S/N A1520825 N7607SBelle Valle Aviation LLC · St Petersburg, FLBuilt 1978 · S/N 18265255 N7607TVantine Willard W III · Lexington, SCBuilt 1959 · S/N 47207 N7607WZero Seven Whiskey LLC · Dewey, OKBuilt 1977 · S/N R18200066 N7607XHall Douglas F · Pembine, WIBuilt 1960 · S/N 17248107 N7608FAj Mush LLC · Dearborn, MIBuilt 1979 · S/N 17273266 N7608MInspiration Aviation LLC · Mesa, AZBuilt 1959 · S/N 55908 N7608SMkc Flying LLC · Gladstone, MOBuilt 1976 · S/N 18265256 N7608XStanton Todd D · Plains, KSBuilt 1960 · S/N 17248108 N76091Riverside Flight Academy Inc · Riverside, CAS/N 17268121

Back to AD 87-20-03 R2