Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N252ZCRegistration Pending · Sheridan, WYRegistration pendingBuilt 1987 · S/N 25-1099 N252ZEFlorida Flying Tigers LLC · Brandon, FLS/N 25-1105 N2530MHoward Robert Thomas · Palmdale, CABuilt 1977 · S/N 28R-7803132 N2542SSierra Systems LLC · Emigrant, MTBuilt 1968 · S/N 337-0842 N25460Kleen Sheen IV LLC · Bowling Green, KYBuilt 1985 · S/N 34-8533041 N254CDMaw Energy LLC · Hagerman, NMBuilt 2002 · S/N 1166 N254WTClik Services LLC · Forestdale, MABuilt 1968 · S/N 337-0921 N255Sunset Aviation LLC · Klamath Falls, ORBuilt 1975 · S/N P3370213 N2554SHanan Roy T · Edgewater, FLS/N 337-0854 N2556QDuan Yutao · Walnut, CABuilt 1977 · S/N 28R-7703068 N255DDAlifarhani David · Vestavia, ALBuilt 2000 · S/N 1095 N2562DWalker Garrett J · Anchorage, AKBuilt 1952 · S/N 20714 N2567VHarness Ben · Covelo, CAFirst renewal noticeBuilt 1976 · S/N R1722223 N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869 N256SJSan Juan Aviation LLC · Wilmington, DEBuilt 1979 · S/N R1723166 N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875 N2576MEsposito Joseph Salvatore · Jacksonville, FLBuilt 1977 · S/N 28R-7803133 N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877 N2579SMenagh Bret J · Fresno, CABuilt 1968 · S/N 337-0879 N257CDPahlavan Benham A · Santa Rosa, CABuilt 2002 · S/N 1184 N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887 N2588QDlp Ventures LLC · North Platte, NEBuilt 1977 · S/N 28R-7703070 N258CDWyman Michael J · Greenville, SCBuilt 2002 · S/N 1186 N259Clark Jack E Jr · Mesa, AZFirst renewal noticeBuilt 1975 · S/N P337-0220 N2597UBelisle Johnny E · Camden, TNBuilt 1979 · S/N 28R-7931290 N25ADPaxton Homes LLC · Killeen, TXBuilt 1983 · S/N 348333001 N25PDKnew Man Group LLC · New Orleans, LABuilt 1994 · S/N 3448050 N25WLSchein William · Santa Fe, NMBuilt 1992 · S/N 25 N2601RHarden Aviation LLC · Washington, PABuilt 1969 · S/N 28R-35223 N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904 N2606UJanovyak Aviation LLC · Lockport, ILBuilt 1979 · S/N 28R-7931291 N260STPitts S2b LLC · Salinas, CABuilt 1981 · S/N 34-8133047 N2610Avionicos Corp · Nokomis, FLBuilt 1977 · S/N 34-7770428 N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910 N2611MOlsen Robert F · Chatham, MABuilt 1977 · S/N 28R-7803138 N2612SNixon Edward J · Collierville, TNS/N 337-0912 N2617SPlummer Kenneth W · Sullivan, INBuilt 1968 · S/N 337-0917 N2618MSoltis Stephen T · Kingsport, TNBuilt 1977 · S/N 34-7870089 N2618SOldham Richard · Quartzsite, AZBuilt 1968 · S/N 337-0918 N261CBGober Charles K · Sand Springs, OKBuilt 1980 · S/N 25-0391 N261CDQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 1182 N261DBKhamer Laasn LLC · Longmont, COBuilt 1986 · S/N 25-1083 N261LABrown Jeffrey L · Mint Hill, NCBuilt 1979 · S/N 25-0275 N261RTjarks Edward F · Mesa, AZBuilt 1980 · S/N 25-0392 N261RJJaycobs Richard · Siasconset, MABuilt 1983 · S/N 25-0749 N261TAMiller Shawn M · Canovanas, PRS/N 25-0340 N261TGCirrus Digital LLC · Asheville, NCBuilt 1983 · S/N 250757 N262Run For The Hills LLC · Kalispell, MTBuilt 1975 · S/N P3370217 N2626MBristow Paul M · Burleson, TXBuilt 2001 · S/N 2881 N2628SSpencer Bennett E · Cleburne, TXBuilt 1968 · S/N 337-0928

Back to AD 81-13-10 R1