Skip to content

Registered aircraft · 54,019

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.

N25557All Aviation Xp LLC · Parkland, FLBuilt 1977 · S/N 15280729 N2555CLatham David C · Weld, MEBuilt 1954 · S/N 26199 N2555JRabenaldt Gilbert P · Telferner, TXRegistration revokedBuilt 1965 · S/N 15061055 N2555LGates Kimberly B · Kintnersville, PABuilt 1967 · S/N 17255755 N2555UBurull Donald E · Wichita, KSBuilt 1963 · S/N 17250155 N25564Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280732 N25567Ellingwood Kevin J · Williamstown, MABuilt 1977 · S/N 15280735 N2556KCarlson Steven J · Fairbanks, AKS/N 18052986 N2556VLester Paul W · Hurricane, UTBuilt 1948 · S/N 18061 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2556YZeafla Randall R · Elizabethtown, KYBuilt 1962 · S/N 17249856 N25572Gruetzmacher Marcus Darren · Goliad, TXBuilt 1977 · S/N 15280738 N25573Adjoodani Farhad F · Glen Burnie, MDBuilt 1977 · S/N 15280739 N25575Pierce John S · Delevan, NYBuilt 1977 · S/N 15280741 N2557CJmte Aviation LLC · Appleton, WIBuilt 1954 · S/N 26201 N2557DFullerton John R · Fairbanks, AKFirst renewal noticeS/N 20709 N2557JSale Reported · Lake Havasu City, AZSale reported, canceledBuilt 1964 · S/N 15061057 N2557LSparks Ryan J · Peculiar, MOBuilt 1967 · S/N 17255757 N2557RWhite Willis W · Boise, IDBuilt 1967 · S/N 18258257 N2557SAgri-Flight LLC · Waterford, MIS/N R18201349 N2557UWings Of Hope · Chesterfield, MOBuilt 1963 · S/N 17250157 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2557YSaddle Mountain LLC · Cave Creek, AZBuilt 1962 · S/N 17249857 N25582Heavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15280746 N2558DClayton Alfred T Jr · Anchorage, AKBuilt 1952 · S/N 20710 N2558GScolari Shawn Fenton · Meeteetse, WYS/N 51858 N2558JHay Douglas E · Anza, CABuilt 1965 · S/N 15061058 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N2558RKahn Steven P · Boise, IDBuilt 1967 · S/N 18258258 N2558UDelany Patrick J · Marion, TXBuilt 1963 · S/N 17250158 N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482T N2559LFlying Circus LLC · Bridgeport, WVBuilt 1967 · S/N 17255759 N2559QJordan Valley Aviation LLC · Jordan Valley, ORBuilt 1966 · S/N 18257759 N2559USnake River Flying Club LLC · Horseshoe Bend, IDBuilt 1963 · S/N 17250159 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N2559YA & D Precision Machining Inc · Fremont, CAS/N 17249859 N255EWollak John M · Mount Vernon, WABuilt 1976 · S/N 15078149 N255KRAvra Valley Flyers LLC · Gilbert, AZS/N 172-69860 N255PAAndresen Paul S · Chandler, AZBuilt 1955 · S/N 26735 N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655 N25604Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 15280762 N25608Smith Boyd · Goshen, INBuilt 1977 · S/N 15280764 N2560GJackson Air LLC · Temecula, CABuilt 1959 · S/N 51860 N2560JSmith Douglas J · Sidney, OHBuilt 1964 · S/N 15061060 N2560USpangenberg Daniel M · Greenville, MIBuilt 1963 · S/N 17250160 N2560VCrowley John Arthur · Visalia, CABuilt 1948 · S/N 18065 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N25610Painter Bryan · Renton, WABuilt 1977 · S/N 15280766 N2561QMariposa Aviation Inc · East Wenatchee, WABuilt 1966 · S/N 18257761 N2561RHeber Valley Flying Club · Park City, UTBuilt 1967 · S/N 18258261

Back to AD 87-20-03 R2