Skip to content

Registered aircraft · 54,015

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.

N7354GRight Rudder LLC · Rexburg, IDFirst renewal noticeBuilt 1970 · S/N 17259054 N7354HSale Reported · Madison, ALSale reportedBuilt 1981 · S/N 18267909 N7354NGilleland Earl C · Oakwood, GABuilt 1974 · S/N 18263138 N7354QRegistration Pending · Austin, MNRegistration pendingBuilt 1972 · S/N 18260994 N7354SHobbs Meeks Victoria · Miami, FLBuilt 1976 · S/N 18265145 N7354TAching Raul E · Yuma, AZBuilt 1959 · S/N 46954 N7354VKing Daddy Aviation LLC · Meridian, MSBuilt 1977 · S/N R1722304 N7354XMartin Veronica S · Dover, DEBuilt 1962 · S/N 15059454 N7355AOwens Duane Curtis · Spirit Lake, IDBuilt 1956 · S/N 29455 N7355GAerolanding LLC · Enterprise, ALBuilt 1970 · S/N 17259055 N7355XNorman Robert Alan · Zanesville, OHBuilt 1962 · S/N 15059455 N73560Gospel Ministries International Inc · Collegedale, TNBuilt 1976 · S/N 17267539 N73562Steiger Michael P · Cypress, TXBuilt 1976 · S/N 17267541 N73563Hamms Lake Development Inc · Crown Point, INBuilt 1976 · S/N 17267542 N73565Thompson Teresa M · Grants Pass, ORBuilt 1976 · S/N 17267544 N7356ALittrell Thomas W · Galax, VABuilt 1956 · S/N 29456 N7356EJouppi Kenneth J · Ward Cove, AKBuilt 1959 · S/N 57056 N7356GHolcomb John R · Siloam Springs, ARBuilt 1970 · S/N 17259056 N7356SSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 18265147 N73573Sullins Tyler L · Boerne, TXBuilt 1976 · S/N 17267550 N73574Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17267551 N73577Benton Frederick N · Weed, CAFirst renewal noticeBuilt 1976 · S/N 17267554 N73579Officer Properties LLC · Broken Arrow, OKBuilt 1976 · S/N 17267556 N7357AHultquist David D · Anchorage, AKBuilt 1956 · S/N 29457 N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945 N7357FLittle Bird Airways LLC · Hamburg, NYS/N 15066920 N7357XBurbeck Nathan J · Fort Bragg, CABuilt 1962 · S/N 15059457 N73581Beaumont Ladonna L · Athol, IDBuilt 1976 · S/N 17267557 N73585Anderson Dale S · Corona, CABuilt 1976 · S/N 17267559 N7358AWells Jason T · Mt Hood Prkdl, ORBuilt 1956 · S/N 29458 N7358GN7358g Inc · Las Vegas, NVBuilt 1970 · S/N 17259058 N7358NHnat Peter Paul · Foresthill, CABuilt 1974 · S/N 18263142 N7358SHittle Thomas W · East Haven, CTBuilt 1976 · S/N 18265149 N73596Russellville Aviation Inc · Russellville, ARBuilt 1976 · S/N 17267567 N7359CAhlem Charles D · Hilmar, CABuilt 1977 · S/N U20603897 N7359EHomes Richard Bryant · Charleston, SCBuilt 1984 · S/N 18268380 N7359TKort Thomas J · Lake Tomahawk, WIBuilt 1977 · S/N R18200031 N7359XLawson William L · Decatur, MIBuilt 1961 · S/N 15059459 N735AAKnight Kevin D · Hereford, TXBuilt 1976 · S/N 18265260 N735ABPapalote Ranches LLC · Missoula, MTBuilt 1976 · S/N 18265261 N735ACKempton Larry G Jr · Grand Junction, COBuilt 1976 · S/N 18265262 N735ADMassery Dean P · Lake Milton, OHBuilt 1976 · S/N 18265263 N735AFJanssen Rod · Beaufort, SCBuilt 1976 · S/N 18265265 N735AHMark R Cooper Aviation LLC · Fort Wayne, INBuilt 1976 · S/N 18265267 N735AKKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265269 N735ALGml Flight Service LLC · Las Cruces, NMBuilt 1976 · S/N 18265270 N735AMJohnson Mark S · Bremerton, WABuilt 1976 · S/N 18265271 N735ANAmerican Eagle Flying Club · New Hudson, MIBuilt 1976 · S/N 18265272 N735APJay Bee Aviation LLC · Okeechobee, FLBuilt 1976 · S/N 18265273 N735ARHaller Michael J · Clayton, NCBuilt 1976 · S/N 18265275

Back to AD 87-20-03 R2