Skip to content

Registered aircraft · 54,017

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.

N522DCBateson Mark A · Roseville, CABuilt 1974 · S/N 17263169 N522DRIbrahim Tarek M · Lawrenceville, VABuilt 1966 · S/N 15063327 N522FN522f LLC · Titusville, FLBuilt 1970 · S/N 17258510 N522GCCorkins Research LLC · Greenacres, FLBuilt 1979 · S/N 172RG0091 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N522JHMinor Steve A · Twain Harte, CAS/N 55902 N522KSkyhigh Aviation Investments Inc · Daytona Beach, FLBuilt 1974 · S/N 15075544 N522LMutai Samson Kipruto · Lenexa, KSBuilt 1960 · S/N 57516 N522SKMajor Air LLC · Charleston, SCBuilt 1980 · S/N 17274456 N522SSSouthern Seaplane Inc · Belle Chasse, LABuilt 1982 · S/N 18504388 N522TSFerraraccio Christopher M · Clarksville, TNBuilt 1961 · S/N 17248805 N522XSkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 17252411 N52301Harmes Brian M · Harrisburg, PABuilt 1973 · S/N 18262515 N52304Haney Michael W · Tehachapi, CABuilt 1973 · S/N 18262516 N52305Ada Forestry Division · Malvern, ARBuilt 1973 · S/N 18262517 N52306Scott Construction Inc · Lake Delton, WIBuilt 1973 · S/N 18262518 N52308Registered aircraftBuilt 1973 · S/N 18262520 N5230EBrentco Aerial Patrol Inc · Canton, OHBuilt 1983 · S/N 18268301 N5230NHostetler Todd · Wausau, WIBuilt 1980 · S/N 18267586 N5230UAllen Etienne · Simi Valley, CABuilt 1964 · S/N 206-0230 N52314Universal Aviatiors Academy Inc · El Monte, CABuilt 1973 · S/N 18262521 N52318Shephard Donald · Lake Havasu City, AZBuilt 1973 · S/N 18262524 N5231DDixon Douglas C · Anchorage, AKBuilt 1958 · S/N 50129 N5231HTilley Daniel D · Grove City, OHBuilt 1975 · S/N 17265379 N5231NBrothers Implement Co Inc · Hillsboro, TNBuilt 1980 · S/N 18267587 N5231QMonti David G · Middleport, NYBuilt 1965 · S/N 17253288 N5231RPml Aero Club LLC · Groveland, CABuilt 1974 · S/N 17263445 N5231TRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1981 · S/N R18201839 N5231VGibson John V Jr · Yardley, PABuilt 1977 · S/N R1722284 N52321Kowal Steven K · Annapolis, MDBuilt 1973 · S/N 18262526 N52322Flat Top Energy LLC · Ghent, WVBuilt 1973 · S/N 18262527 N52324Hailey Jeremy A · Burlington, WABuilt 1973 · S/N 18262528 N52328Ethridge Ed · Bigfork, MTBuilt 1973 · S/N 18262530 N52329Heber James A · Gansevoort, NYBuilt 1973 · S/N 18262531 N5232DVella David A · Scottsboro, ALBuilt 1979 · S/N 17272461 N5232FGilbert Christopher J · Edmonds, WABuilt 1965 · S/N 17253291 N5232KStick & Rudder Club Inc · Waukegan, ILBuilt 1980 · S/N 17274024 N5232NFlorida Gas Transmission Co · Spring, TXBuilt 1980 · S/N 18267588 N5232UScruggs Kenneth R · Galloway, OHBuilt 1964 · S/N 206-0232 N52330Morgan John E · Waverly, TNS/N 18262532 N52331St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1980 · S/N 17274494 N52332Beta Fleet LLC · South Burlington, VTBuilt 1973 · S/N 18262534 N52334Cooper Edwin H Jr · Austin, TXBuilt 1973 · S/N 18262536 N52337Willson Collin R · Lake Saint Louis, MOBuilt 1973 · S/N 18262538 N5233ERichmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 17271786 N5233PAero Quest LLC · Olive Branch, MSBuilt 1981 · S/N 15284898 N5233UKenai Gravel Products LLC · Salt Lake City, UTFirst renewal noticeBuilt 1964 · S/N 206-0233 N52341Pacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274496 N52342Child Todd A · Salt Lake City, UTBuilt 1974 · S/N 18262542 N52344My Toys Inc · Spartanburg, SCBuilt 1980 · S/N 17274497

Back to AD 87-20-03 R2