AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N27150Auspex Inc · Houston, TXBuilt 1979 · S/N AA5A0875N27155Registered aircraftBuilt 1979 · S/N AA5A0879N27156Dailey Hadrian B · Churchville, NYBuilt 1979 · S/N AA5A0880N2715FLow Wings Aviation LLC · Gassville, ARBuilt 1965 · S/N 18256815N2715PNefstead Charles R · Willmar, MNBuilt 1955 · S/N 22-3021N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214N2715YEmerson Michael J · Athens, ALBuilt 1958 · S/N TD-62N2716PNeno Richard J · Ithaca, NYBuilt 1957 · S/N 22-5280N2716WBig Sky Aviation LLC · Meridian, IDBuilt 1966 · S/N 1025N2716XShaw Brandon L · Juneau, AKBuilt 1965 · S/N 18051516N2716ZWilson Miles · Mcminnville, TNBuilt 1978 · S/N 354-78N27176Rayfield Wm Preston · Columbiana, ALBuilt 1979 · S/N AA5A-0899N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049N2717GKlotz Terrance M · Sparks, NVBuilt 1959 · S/N 52017N2717TIberlin James M · Gillette, WYBuilt 1967 · S/N TE-351N2718AOmega2alpha Services LLC · Brock, TXBuilt 1969 · S/N CD-1231N2718FJackalope Flyers LLC · Whitefish, MTBuilt 1965 · S/N 18256818N2718QJenerette Marcus · Galivants Ferry, SCBuilt 1967 · S/N 18257918N2718XPoirier Theodore N · Biddeford, MEBuilt 1965 · S/N 18051518N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232N2719FSjoblom Erik Anders · Washington Twp, MIBuilt 1966 · S/N 18256819N2719MCenter Charles C · Wasilla, AKBuilt 1946 · S/N 12-1216N2719RJenkins Bruce D · New Market, MDBuilt 1969 · S/N 28R-35265N2719WNance Russell · Pelion, SCBuilt 1966 · S/N 1026N271APatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2002 · S/N 905-2002N271AFBurke Aircraft Service Co LLC · Portsmouth, OHBuilt 2003 · S/N 18281188N271AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881989N271AMMonthy Christian · Van Nuys, CABuilt 1973 · S/N 17262510N271BSheridan Jeffrey Stephen · Lakeville, MNBuilt 1959 · S/N 129N271CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13090N271CCL-Bird LLC · Hood River, ORBuilt 2000 · S/N 9918CCN271DCForum Aviation LLC · Middletown, DEBuilt 2005 · S/N 18281579N271DGMa King LLC · Stanwood, WABuilt 1987 · S/N S1288N271DWBundock David · Wayne, NJBuilt 1988 · S/N 5136N271EXTakacs John Paul · Portland, ORBuilt 2024 · S/N 1N271FKPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 12394N271GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881114N271GTBroulik Robert L · Lisbon, IABuilt 1976 · S/N 17267114N271HWHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020271N271JGoossen Luke A · Rosamond, CABuilt 1994 · S/N 271N271MAWing Runner Aviation LLC · Lakewood Ranch, FLBuilt 2003 · S/N 475-2003N271MDDismore Matthew · Gulfport, MSBuilt 1979 · S/N 32-7940232N271MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881453N271MLKeyser Gary E Trustee · Reno, NVBuilt 2024 · S/N 91620N271MMFoster Gregory A · Saginaw, MNBuilt 2000 · S/N 003N271MWRobinson Loren L · Newark, DEBuilt 1998 · S/N 067N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N271PTPinder Jason · Sheridan, WYS/N 20271N271RGCapitol City Flyers Inc · Madison, WIBuilt 1978 · S/N R18200528N271SBowker Mark · Bowdoinham, MEBuilt 1974 · S/N TC-1791
Back to AD 2007-04-19 R1