Skip to content

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N2712QGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 18257912 N2713GPalmer Carroll W · Harper, ORBuilt 1959 · S/N 52013 N2713QJeff Jones Aircraft Company LLC · Quincy, WABuilt 1967 · S/N 18257913 N2714FDdh LLC · Goddard, KSBuilt 1965 · S/N 18256814 N2714GRegistered aircraftBuilt 1959 · S/N 52014 N2715FLow Wings Aviation LLC · Gassville, ARBuilt 1965 · S/N 18256815 N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516 N2717GKlotz Terrance M · Sparks, NVBuilt 1959 · S/N 52017 N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818 N2718QJenerette Marcus · Galivants Ferry, SCBuilt 1967 · S/N 18257918 N2718XPoirier Theodore N · Biddeford, MEBuilt 1965 · S/N 18051518 N2719FSjoblom Erik Anders · Washington Twp, MIBuilt 1966 · S/N 18256819 N271AFBurke Aircraft Service Co LLC · Portsmouth, OHBuilt 2003 · S/N 18281188 N271DCForum Aviation LLC · Middletown, DEBuilt 2005 · S/N 18281579 N271RGCapitol City Flyers Inc · Madison, WIBuilt 1978 · S/N R18200528 N271SLVan Bortel Aircraft Inc · Arlington, TXBuilt 2024 · S/N 18283271 N271SPIndiana Department Of Administration · Greenwood, INBuilt 2000 · S/N 18280911 N2720GGenstler Jeremy A · Apple Valley, CABuilt 1959 · S/N 52020 N2720QDelta Yankee Aviation LLC · Anguilla, MSBuilt 1967 · S/N 18257920 N2720XStubbs John C · Bangor, MEBuilt 1965 · S/N 18051520 N27216Jjep Aviation LLC · Seattle, WABuilt 1998 · S/N 18280320 N2721QN2721q LLC · Stuart, FLBuilt 1967 · S/N 18257921 N2722FBowen Michael D DBA · Noblesville, INBuilt 1998 · S/N 18280352 N2722GEpperson David C · Salt Lake City, UTFirst renewal noticeBuilt 1959 · S/N 52022 N2722XRearden Michael B · Homer, AKBuilt 1965 · S/N 18051522 N2723FTrantham Robert Keith · Alexandria, ALBuilt 1966 · S/N 18256823 N2723GReno Timothy J · University Place, WABuilt 1959 · S/N 52023 N2724FIsley Rocky · Lacey, WABuilt 1965 · S/N 18256824 N2724REcho Flight LLC · Tucson, AZBuilt 1998 · S/N 18280322 N2724XParrott Charles F · Bridgton, MEBuilt 1965 · S/N 18051524 N2725F85 Charlie Papa LLC · Phoenix, AZBuilt 1965 · S/N 18256825 N2726GFarmhouse Aerospace LLC · Laurel, MTBuilt 1959 · S/N 52026 N2726XSuttman Robert · Dayton, OHBuilt 2007 · S/N 18281913 N2727QEstes Gregory T · Jonesville, VABuilt 1967 · S/N 18257927 N2728BBig Island Gravity LLC · Kapaau, HIBuilt 1959 · S/N 52028 N2728XUsda Forest Service Fepp · Trenton, NJBuilt 1965 · S/N 18051528 N2729FSexton & Sanders Law Firm Pa · Fort Smith, ARBuilt 1965 · S/N 18256829 N2729QCraft Phyllis C · Damascus, GABuilt 1967 · S/N 18257929 N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193 N272CGStrickland Luther J Jr · San Luis Obispo, CABuilt 1949 · S/N 7301 N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402 N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939 N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362 N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930 N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530 N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045 N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931 N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202 N2732GPrince Benjamin D · Lincoln, MTS/N 52032 N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046

Back to AD 84-10-01 R1