Registered aircraft · 54,021

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.

N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419 N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421 N1297DPerk LLC · Glendale, AZBuilt 1951 · S/N 19873 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429 N1298DGlaser Gerald A · Sebastopol, CABuilt 1951 · S/N 19874 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N129MDMiller Glen S · Brenham, TXS/N 56430 N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291 N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903 N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732 N12GZBoettcher Aerial Co Inc · Beloit, KSBuilt 1974 · S/N 18801619 N12HBAerotechniques LLC · South Kent, CTBuilt 1977 · S/N 177RG1124 N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707 N12JIsland Aviators LLC · Grosse Ile, MIBuilt 1977 · S/N R1722455 N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365 N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841 N12JTHines Thomas J · Amsterdam, NYBuilt 1972 · S/N 15073955 N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915

Back to AD 87-20-03 R2