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.

N19255Arnett Donald K · Miami, FLBuilt 1973 · S/N 15074278 N19256Baker Bobby J · Marianna, FLS/N 15074279 N19258Thompson William Thomas · Antioch, ILBuilt 1973 · S/N 15074281 N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431 N1925QReagan Amber J · Mcalester, OKBuilt 1973 · S/N 177RG0325 N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025 N1925ZButenhoff Harold M · Leonard, NDBuilt 1962 · S/N 15059725 N19261Dancis Air LLC · Wynnewood, PABuilt 1973 · S/N 15074283 N19267Take Angels Aviation LLC · Watertown, NYBuilt 1973 · S/N 15074288 N19268Youderian Kenneth E · Coupeville, WAFirst renewal noticeBuilt 1973 · S/N 15074289 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503 N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287 N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026 N1926ZBeville Robert M · Newberry, FLBuilt 1962 · S/N 15059726 N19271Carnathan Davette Layne · Shannon, MSBuilt 1973 · S/N 15074292 N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566 N19276Neel Aviation LLC · Lakeland, FLBuilt 1973 · S/N 15074295 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857 N1927ZBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 15059727 N19280Mouton Charles J Jr · Gladewater, TXBuilt 1973 · S/N 15074299 N19282Hall Robert M · New Bern, NCBuilt 1973 · S/N 15074301 N19288Driscoll John J · Manvel, TXBuilt 1973 · S/N 15074306 N19289N19289 LLC · Pageland, SCBuilt 1973 · S/N 15074307 N1928CLafon Daniel L · League City, TXS/N 26073 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019 N1928QWhite David D · Arcata, CABuilt 1973 · S/N 177RG0328 N1928ZRegistration Pending · Sunbury, PARegistration pendingBuilt 1963 · S/N 15059728 N19290Crady Brian · Spring, TXBuilt 1973 · S/N 15074308 N19294Eminger Mark E · Cloverdale, INBuilt 1973 · S/N 15074312 N19298Aero Maintenance Inc · Vancouver, WABuilt 1973 · S/N 15074316 N19299Wilkes David D · Deer Park, WAS/N 15074317 N1929CWyborny Wendell R · Cypress, TXBuilt 1953 · S/N 26074 N1929ZKotter Julie B · Metropolis, ILS/N 15059729 N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N192CWBowen Jeffrey Charles · Frankston, TXBuilt 1979 · S/N R1723092 N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020 N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979 N192JRCessna 185 LLC · Birmingham, MIS/N 18502286 N192PMScheib Michael A · Dauphin, PABuilt 1967 · S/N 15067467 N19302Halverson Mark S · Mason City, IABuilt 1973 · S/N 15074319 N19303Saini Vijay S · Saint Petersburg, FLBuilt 1973 · S/N 15074320 N19305Surface To Air Corp · Wilmington, DEBuilt 1973 · S/N 15074322 N19306Barr Shane G · Wexford, PABuilt 1973 · S/N 15074323 N1930CChidekel Philip M · Chadds Ford, PABuilt 1953 · S/N 26075 N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798 N1930XDuff James J · Pueblo, COBuilt 1965 · S/N 18256030 N19312Morley Thomas O · Riverside, CABuilt 1973 · S/N 15074329

Back to AD 87-20-03 R2