Skip to content

Registered aircraft · 4,000

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.

N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074 N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10 N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16 N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075 N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210 N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291 N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052 N1007XD&R LLC · Emory, TXS/N 34-7570182 N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116 N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183 N10162Crespi Tony D · Meriden, CTBuilt 1981 · S/N 25-0561 N10165N10165 Corp Trustee · Wilmington, DEBuilt 1981 · S/N 25-0562 N10167Sterling Air LLC · La Quinta, CABuilt 1981 · S/N 25-0563 N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727 N1016VPlowright Aviation LLC · Aldie, VAS/N R1722082 N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547 N1017JEvans Phillip R · Dinuba, CABuilt 1972 · S/N 17 N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615 N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564 N1019JPeterson George D · Key West, FLS/N 19 N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037 N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588 N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631 N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086 N1026JRodriguez Luis Jr · Columbus, GABuilt 1972 · S/N 26 N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215 N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024 N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016 N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N102WBArtemis Inc · Hauppauge, NYBuilt 1968 · S/N 337M0104 N102WLBoyd Stanley E · Placitas, NMBuilt 1987 · S/N 59 N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216 N1032VMatlock Jimmy R · Granbury, TXBuilt 1976 · S/N R1722088 N103ALJordan John S · Sullivan, MOBuilt 1977 · S/N 0599 N103GSDuce Phillip N · Kotzebue, AKBuilt 1975 · S/N 6079C N1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090 N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567 N1047AHolt Sheet Metal Inc · Durango, COBuilt 1981 · S/N 25-0571 N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049 N1049DChihuahua Airport Partners Lp · Plano, TXBuilt 1975 · S/N 0015 N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309 N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163 N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N1054VNorthington Neill · Fredericksburg, TXBuilt 1976 · S/N R1722094 N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195 N1055VWarner Alan P · Carpinteria, CABuilt 1976 · S/N R1722095

Back to AD 81-13-10 R1