Skip to content

Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N4930VCirrusly LLC · Bonney Lake, WABuilt 2004 · S/N 0960 N4931CEinstein Inc · Price, UTBuilt 1975 · S/N 18502662 N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448T N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668T N4934EHeineman Steven · Chicago, ILBuilt 1979 · S/N 18503912 N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634 N4935QHaygar Berlin Inc · Shorewood, MNBuilt 1978 · S/N 18503578 N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952 N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454T N4938AK E R Air LLC · Fort Myers, FLBuilt 1978 · S/N 310R1406 N4939CBard Ralph M · Tullahoma, TNBuilt 1979 · S/N 21063680 N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456T N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050 N493CDCocozzoli Kevin A · Crestview, FLBuilt 2005 · S/N 1603 N493KPCatalano Gerry · Shingle Springs, CABuilt 1988 · S/N CE-1231 N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376 N4941AMartinello Domenic · Clarksville, TNBuilt 1978 · S/N 310R1407 N4941VClark Robert J · Brookshire, TXS/N 30146 N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642 N4943EPettit Robert · Carnegie, OKS/N 18503914 N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461T N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145 N4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeBuilt 1979 · S/N 18503916 N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378 N4946VJennings Carl M · Au Gres, MIS/N 30148 N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682T N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410 N4948CRobillard Ross · Eveleth, MNBuilt 1975 · S/N 18502664 N4948QWhite Ronald A · Anchorage, AKBuilt 1978 · S/N 18503583 N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465 N4948URegistered aircraftBuilt 1965 · S/N 21058648 N4949ASw Air LLC · Denver, COS/N 310R1505 N4949ETrans Crafts LLC · Big Lake, AKBuilt 1979 · S/N 18503917 N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466T N494AStotlar William B · Pinckneyville, ILBuilt 1967 · S/N TE-370 N494PGarrett Jacob Y · West Plains, MOBuilt 1993 · S/N CE-1738 N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156 N494RJIsaacson Keith B · New Orleans, LABuilt 2009 · S/N E-3898 N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201 N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487 N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810 N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174 N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055 N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651 N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057 N4952EHess Michael D · Wasilla, AKBuilt 1979 · S/N 18503918 N4953EInland Fisheries And Wildlife · Augusta, MEBuilt 1979 · S/N 18503919 N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058 N4956MMurray Timothy · Orlando, FLBuilt 1978 · S/N CE-781 N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657

Back to AD 86-13-04 R3