Skip to content

Registered aircraft · 7,764

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

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000 N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509 N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489 N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370 N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800 N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215 N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216 N101JKKaras Dean · Lansing, KSS/N 28R-7335243 N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080 N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219 N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220 N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074 N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036 N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181 N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198 N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222 N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131 N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951 N103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097 N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092 N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199 N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223 N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224 N10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279 N1049XValleyside Farm LLC · Woodstock, CTBuilt 1975 · S/N 32-7540132 N1054QTaylor Hauling II LLC · Laurel, MSBuilt 1977 · S/N 32-7740045 N1057XWeisenberger Thomas · Norwalk, OHBuilt 1975 · S/N 28-7505202 N105DYYeager Daniel C · Iowa City, IABuilt 1966 · S/N 32-467 N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163 N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104 N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015 N1062UNathan John K · Seabrook, TXS/N 32-40070 N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204 N1069XEntelechy One LLC · Wichita, KSBuilt 1975 · S/N 32-7540134 N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704 N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206 N1073XAustin Arrows Inc · Austin, TXBuilt 1975 · S/N 28R-7535232 N1077XJny LLC · Riverview, FLBuilt 1975 · S/N 28R-7535234 N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236 N108WMMoran William J · Media, PABuilt 1978 · S/N 32-7840187 N1092XNice Curtis A · Lawrenceburg, INBuilt 1975 · S/N 28R-7535230 N1094TGlover Anthony R · Louisville, KYBuilt 1969 · S/N 28R-31116 N1095XVillegas Miguel Angel Cuello · Weston, FLBuilt 1975 · S/N 28R-7535239 N1099JLee'S Sea Air Inc · Kiana, AKBuilt 1967 · S/N 32-40274 N109ATAguillard Robert N · Memphis, TNBuilt 1974 · S/N 32-7540042 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612

Back to AD 72-17-05