Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N356TAFlyktoc LLC · Lavonia, GABuilt 1976 · S/N 172-67123 N356VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 32-8206008 N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916 N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917 N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207 N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921 N3570EBlackbird Aviation Corp · Van Nuys, CAS/N 17271593 N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925 N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926 N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927 N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928 N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929 N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930 N35718Parmerlee David · Grand Rapids, MIBuilt 1979 · S/N 32R-8013032 N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932 N3571GMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 1080 N3571LPeltier Scott M · Longwood, FLS/N 28-8011071 N3571MCasazza Christian G · Anchorage, AKBuilt 1947 · S/N 12-2419 N3571NCoker Steve L · Tyler, TXBuilt 1967 · S/N 680101 N3571PRegistration Pending · Myrtle Beach, SCRegistration pendingBuilt 1979 · S/N 28-8011069 N3571VLutz Paul A · Seville, OHBuilt 2026 · S/N 05210100 N3571WJtw Financail Services · Norfolk, NEBuilt 1966 · S/N 32-463 N3571ZThompson Lyndon R · West Fargo, NDBuilt 1960 · S/N 18-7349 N35721Bakken Al J · Belgrade, MTBuilt 1941 · S/N 5-762 N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936 N35726Jh Aero LLC · Little Rock, ARS/N 17256937 N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939 N3572BPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-8013033 N3572GHauser Linda · Ulysses, KSBuilt 1964 · S/N 1081 N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356 N3572PMulkey Joshua D · Anchorage, AKS/N 18-4526 N3572QFloyd Richard C · Sutter Creek, CABuilt 1973 · S/N 17261676 N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213 N35730Miner Jay G · Seattle, WABuilt 1968 · S/N 17256940 N35731Registration Pending · Carthage, NCRegistration pendingBuilt 1968 · S/N 17256941 N35732Minney Andrew · Memphis, TNBuilt 1979 · S/N 28-8016195 N35735Gaston Brothers Excavating Inc · Seattle, WAS/N 17256943 N35738Plane Life LLC · Wilmington, DEBuilt 1968 · S/N 17256944 N3573AAlderman Bill A · Chelsea, OKBuilt 1953 · S/N 22-1847 N3573GDuran Robert J · Fort Lupton, COBuilt 1964 · S/N 1082 N3573HBarnes Terry A · Austin, TXBuilt 1977 · S/N 20-1235 N3573MCheney Klyn W · Gooding, IDBuilt 1947 · S/N 12-2420 N3573PStewart James B · Anchorage, AKBuilt 1955 · S/N 18-4527 N3573QFly Lugu LLC · Westfield, MABuilt 1973 · S/N 17261677 N3573WRay Blake · Midland, TXBuilt 1966 · S/N 32-466 N3573ZBlue Ice Aviation Inc · Wasilla, AKBuilt 1960 · S/N 18-7359 N35741Covelli Scott · Spicewood, TXBuilt 1968 · S/N 17256945 N35744Noland Farms Inc · Blue Mound, ILBuilt 1968 · S/N 17256947 N35746Hoard David L · Germantown, TNBuilt 1968 · S/N 17256948 N35748Price Stanley C · Grapevine, TXBuilt 1968 · S/N 17256950

Back to AD 81-18-04 R2