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.

N1351UThomas Jackson Smith · Baton Rouge, LAS/N 17267022N1351WAllen Mark S · Reno, NVBuilt 1963 · S/N 2632N1351ZErickson David R · West Point, UTS/N TC-148N13521Ekberg Jeff M · Emmett, IDS/N 17262817N13522Recker Edward J · Surprise, AZBuilt 1973 · S/N 17262818N13524Loomis Avaition LLC · Columbus, OHBuilt 1973 · S/N 17262820N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433N13527Beekman Gary J · Oconto, WIBuilt 1973 · S/N 17262823N13529Meyer Ricky L · New Liberty, IABuilt 1973 · S/N 17262825N1352EMclv2020 LLC · Las Vegas, NVBuilt 1978 · S/N 17270966N1352JBecker Norbert E · Lake Ozark, MOBuilt 1975 · S/N 352N1352PHouse Travis · Bristow, VABuilt 1955 · S/N 23-401N1352SEjw Enterprises LLC · Aguila, AZS/N 18264915N1352UN19630 LLC · Fort Collins, COBuilt 1976 · S/N 17267023N13535Aviation Academy LLC · Wichita, KSS/N 17262830N13537Sale Reported · Brownsville, ORSale reported, pending cancellationBuilt 1973 · S/N 17262832N13539Pawul Frank A · Graham, WABuilt 1973 · S/N 17262833N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709N1353JBledsoe Robert · Orlando, FLBuilt 1975 · S/N 353N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242N1353SHerrick Kendall D · Johnson, KSS/N 18264916N1353UReynolds Darryl G · Wills Point, TXBuilt 1976 · S/N 17267024N1353YRust Joyce A · Bourbon, INBuilt 1974 · S/N 28-7405152N13540Spangler Taylor L · Andover, KSBuilt 1973 · S/N 17262834N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434N13543Skylink II LLC · Florissant, MOBuilt 1973 · S/N 17262836N13544Registered aircraftBuilt 1973 · S/N 17262837N13548Havana Flyers Assoc · Petersburg, ILBuilt 1973 · S/N 17262840N13549Big Sky Communication & Cable Inc · Billings, MTBuilt 1973 · S/N 17262841N1354ESandra And Mose Rucker III LLC · Perrineville, NJBuilt 1982 · S/N 18268175N1354TRiverside Flight Academy Inc · Riverside, CABuilt 1972 · S/N 28R-7235268N1354UVosskuhler Darlene Duke · Sun City West, AZBuilt 1976 · S/N 17267025N1354ZGallo 12 LLC · Kalispell, MTBuilt 1961 · S/N D-6774N13551Eagle Sky Patrol Inc · Deadwood, SDBuilt 1973 · S/N 17262843N13552Newton Property Leasing LLC · Greene, IABuilt 1973 · S/N 17262844N13555Krueger Steven T · Leander, TXBuilt 1973 · S/N 17262846N13559Bauta Carlos L · Bristol, INBuilt 1973 · S/N 17262848N1355FChi Aerospace Inc · Portsmouth, NHBuilt 1979 · S/N 17272998N1355JHlatshwayo Mbusi S · Alhambra, CABuilt 1975 · S/N 355N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755N1355SFlight Services Limited LLC · Bennett, COBuilt 1976 · S/N 18264918N1355WBloch Matthew William · Marquette, MIS/N 2636N1355ZEnns Nathan G · Shafter, CABuilt 1961 · S/N D-6775N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1356FJprg Aviation Inc · Orlando, FLS/N 17272999N1356MYbarra Xavier · Uvalde, TXS/N 18264294N1356QRouth Frank D · Marion, NCBuilt 1982 · S/N JAR-1N1356STc Aviation LLC · Atlanta, GABuilt 1976 · S/N 18264919N1356UN1356u LLC · Wilmington, DEBuilt 1976 · S/N 17267027
Back to AD 2007-04-19 R1