OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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

N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16N1011JJames Robert L · East Setauket, NYBuilt 1972 · S/N 11N1017JEvans Phillip R · Dinuba, CABuilt 1972 · S/N 17N1017TShelton Steven · Baltimore, MDBuilt 1975 · S/N 403N1019JPeterson George D · Key West, FLS/N 19N1021JJefferson Patrick Dixon · New Braunfels, TXS/N 21N1026JRodriguez Luis Jr · Columbus, GABuilt 1972 · S/N 26N1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1040JHefferon John W · Locust Grove, GABuilt 1973 · S/N 40N1043JLanmon Herman Jr · Hamilton, TXBuilt 1974 · S/N 127N1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47N1049JLoxley Jason C · Virginia, ILBuilt 1972 · S/N 49N1056JPowell John F · Sunnyvale, CABuilt 1973 · S/N 56N1057JMccann Air Corp · Wilmington, DEBuilt 1973 · S/N 57N1058JMoon Valley Aviation LLC · Ozark, MOBuilt 1973 · S/N 58N1059JMayes Ricky · Winston Salem, NCBuilt 1973 · S/N 59N1069JLoomis Adra A · Weldona, COBuilt 1973 · S/N 69N1071JMoore Bradford H · Severna Park, MDBuilt 1973 · S/N 71N1072JAcorn Veterinary Services · Woodstock, VABuilt 1973 · S/N 72N1074JShevitski Jeffrey · New Castle, PABuilt 1973 · S/N 74N1075JTise Marcelo D · South Hackensack, NJBuilt 1973 · S/N 75N1076JRichards Steven P · Lockport, NYBuilt 1973 · S/N 76N1077JAlttitude With Attitude LLC · Elizabethtown, PAS/N 77N1079JElmore Danny W · Othello, WAS/N 124N1081JSoto Osvaldo · Myersville, MDBuilt 1973 · S/N 81N1085JFloyd Shea · Brownfield, TXBuilt 1973 · S/N 85N1086JRidgway Stephen · Avon, COBuilt 1973 · S/N 86N1087JKalivretakis Anthony · Southington, CTS/N 87N1088JDreiling Richard J · Ft Collins, COBuilt 1973 · S/N 110N1089JBradford Johnny E · Sacramento, CABuilt 1973 · S/N 111N1094JBrad Causey · Charlotte, TNBuilt 1973 · S/N 94N1096JFullen Ronnie E · Seguin, TXBuilt 1973 · S/N 96N109JWGoldasich John K · Lomita, CABuilt 1999 · S/N 20025N1102JWorthingstun Dean D · Morganton, GABuilt 1973 · S/N 102N1104JMunn Laurie P · Bellflower, CABuilt 1973 · S/N 104N1105JRla Inc · Lake Linden, MIBuilt 1973 · S/N 114N1108JOehmke Robert R · Southampton, MABuilt 1973 · S/N 108N111HYSch Aviation Inc Trustee · NorfolkS/N 14569N112AZInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 13251N112BAAlford George · Lanett, ALBuilt 1974 · S/N 164N112BMHelbling Robert Jq · Windham, NHBuilt 1974 · S/N 243N112CAWickter Lawrence D Jr · Sugar Grove, ILBuilt 1972 · S/N 23N112CRBlue Side Up Flyers LLC · Fernandina Beach, FLBuilt 1976 · S/N 13078N112DGBarden John · Camp Hill, PABuilt 1973 · S/N 105
Back to AD 2011-07-13