OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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.

N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N113LCLcd Aviation Corp · Wilmington, DEBuilt 1969 · S/N 185-1459N113LSOwnship Aviation Solutions LLC · Huntsville, ALBuilt 1987 · S/N TH1531N113MAMyllyla Ray J · Woodland Hills, CABuilt 1999 · S/N 304N113MEButler Robyn L · Vale, ORS/N 909-76N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96N113MXN113mx LLC · Redding, CAS/N 002N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422N113PCProp & Jet Air Museum Inc · Romoland, CABuilt 1982 · S/N 1N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN113PSSeales Paul · Port Isabel, TXBuilt 2017 · S/N 10011N113PVVaneau Philip M · Kerrville, TXBuilt 1987 · S/N DENTON GIVENS 1N113RVMason Chance L · Elwood, INBuilt 1988 · S/N 1029N113SGRac Global Aircraft Consulting LLC · San Marcos, CABuilt 1976 · S/N 18264758N113SJGlumac Stanley Jr · Grindstone, PABuilt 1993 · S/N 21400N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298N113TBBeaudoin Todd · Castleton, NYS/N 18503772N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281N113TWD'Antoni Gary L · Katy, TXBuilt 1973 · S/N D-9539N113UDRv8rs Anonymous LLC · Cincinnati, OHBuilt 2002 · S/N 80459N113UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1218N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958N113VGN113vg LLC · Princeton, NJBuilt 1993 · S/N 2391N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112N114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215N11421Beach Prairie LLC · Cedar Rapids, IABuilt 2001 · S/N E-3378N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1144FBandit Air LLC · Stowe, PABuilt 1956 · S/N 33279N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185N1144LComposite Sign Products Inc · Zeeland, MIBuilt 1964 · S/N 306N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191
Back to AD 2007-04-19 R1