Skip to content

Registered aircraft · 72,001

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N1963TCondor Aero Club Inc · Zelienople, PABuilt 1971 · S/N 28R-7135192 N1963VFerguson George W · Vero Beach, FLBuilt 1974 · S/N 17263805 N1963WHuertas Andrew C · Tujunga, CABuilt 1973 · S/N MB-627 N1963YLane Cary · Sapello, NMBuilt 1964 · S/N 228 N19640George Gary D · Humble, TXBuilt 1972 · S/N 17260629 N19643Kuester Ryan J · West Point, NEBuilt 1972 · S/N 17260631 N19644Hyde Shawn M · Columbus, OHS/N 17260632 N19646All2fly LLC · Atlanta, GABuilt 1972 · S/N 17260634 N19648Registration Pending · Cumming, GARegistration pendingBuilt 1972 · S/N 17260635 N1964FLombardo Russell S · Fostoria, MIBuilt 1979 · S/N 17273053 N1964SLewis Steve D · Elizabethton, TNBuilt 1963 · S/N 18-8074 N1964XSchachle Robert Godfrey Jr · Wasilla, AKBuilt 2025 · S/N RS1103 N1964YPerry Shawn M · Springfield, OHS/N 229 N19650Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260637 N19655Kincaid William R · Niceville, FLS/N 17260640 N19657Thomas Mark E · Corpus Christi, TXBuilt 1972 · S/N 17260642 N19658Gavel Robert E Jr · Keaau, HIBuilt 1972 · S/N 17260643 N1965PWedell Andrew R · Lumberton, NJBuilt 1955 · S/N 18-4196 N1965YSvoboda Patrick J · Bucyrus, KSBuilt 1964 · S/N 230 N19667Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1972 · S/N 17260650 N19668Yent Kevin N · Tampa, FLBuilt 1972 · S/N 17260651 N19669Sprague John F · Chico, CABuilt 1972 · S/N 17260652 N1966FD & S Aviation LLC · Spring, TXBuilt 1980 · S/N 17273578 N1966LTiger N1966l Corp · New York, NYBuilt 1979 · S/N AA5B1220 N1966PSos David M · Klamath Falls, ORBuilt 1955 · S/N 18-4197 N1966WSale Reported · Southaven, MSSale reportedS/N MB-630 N1966YWeyhrich Dorothy · Windsor, COBuilt 1964 · S/N 231 N19671Cascade Aviation LLC · Burlington, WABuilt 1972 · S/N 17260654 N19674Mcgraw Amiyah S · Jurupa Valley, CABuilt 1972 · S/N 17260657 N19676Whitman David L Jr · Centreville, VABuilt 1972 · S/N 17260659 N19679N19679 LLC · Opa Locka, FLS/N 17260662 N1967FLeander Henry Anske IV · San Antonio, TXBuilt 1967 · S/N 670456 N1967SFullerton Airport Pilot Association · Fullerton, CABuilt 1972 · S/N 17260661 N1967USmith Bernard A · Wasilla, AKBuilt 1968 · S/N 17257827 N1967WNovotny Andrew T · Los Angeles, CABuilt 1974 · S/N MB-656 N19680Proflight Services LLC · West Newton, PABuilt 1972 · S/N 17260663 N19681J & J Shop Heliair LLC · Laurel, DES/N 17260664 N19682Steward James Mark · Colorado Springs, COBuilt 1972 · S/N 17260665 N19684Belt Jay D · Bluefield, WVBuilt 1972 · S/N 17260667 N19687Dg Aviation LLC · Mechanicville, NYBuilt 1972 · S/N 17260670 N19688Vista Air Inc · Pacoima, CABuilt 1972 · S/N 17260671 N1968FMedia Stew LLC · Carson City, NVBuilt 1979 · S/N 17273057 N1968JReid John D · Port Saint Lucie, FLBuilt 2013 · S/N 60-320 N1968PWygant Michelle R · Copper Center, AKBuilt 1957 · S/N 18-4200 N1968SWarbird Adventures Inc · Ocoee, FLBuilt 1992 · S/N 1 N1968TGilbert Zachary A · Jekyll Island, GABuilt 1968 · S/N 32-40376 N19692Babyshark LLC · Duncan, OKS/N 17260675 N19695Saint Aviation Inc · Dunnellon, FLBuilt 1972 · S/N 17260677 N19698Northern Air Aviation LLC · Naples, IDBuilt 1972 · S/N 17260680 N1969EC M & T Aero Inc · Cedar Rapids, IABuilt 1978 · S/N 17271105

Back to AD 87-10-06 R1