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.

N30MEKustudich Tim · Holland, MIBuilt 1985 · S/N MICKELSON-0001N30MKKelly Michael E · Cumberland, RIBuilt 1981 · S/N CE-989N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620N30MTMcnamara J Kevin · Cascade, IDBuilt 1977 · S/N U20604086N30NKOlah Michael J · Mazomanie, WIBuilt 1984 · S/N 162N30NWCenterline Aerospace Inc · Clermont, FLFirst renewal noticeBuilt 1964 · S/N 30-312N30PCHaas Brent R · Willcox, AZBuilt 2026 · S/N 1492-2026N30PHStoneman Thomas K · Friendswood, TXS/N TJ-5N30PMReimer Lynn C · Sioux Falls, SDS/N 2N30PSRosendahl Greg C · Boulder, COS/N K081N30RECalifornia Aviation LLC · Fresno, CABuilt 1979 · S/N 79-30935N30RFBonsal John R · Flower Mound, TXBuilt 1978 · S/N CJ-142N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998N30RMDaniel Warren · Naples, FLBuilt 1971 · S/N TE-828N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050N30RVHarris John W · Lewisville, TXBuilt 1999 · S/N 2025N30RWSaltzy Seas LLC · Loxahatchee, FLBuilt 1976 · S/N 310R0667N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004N30SHMedic Choppers LLC · Springdale, ARBuilt 1966 · S/N 30-1262N30SLAppel Neal C · Prescott, AZBuilt 1972 · S/N E-338N30SSN30ss LLC · Dover, DEBuilt 1973 · S/N 414-0451N30SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11625N30SXRegistration Pending · Painesville, OHRegistration pendingBuilt 1992 · S/N 3025N30TAero Quest LLC · Olive Branch, MSBuilt 1962 · S/N 310G-0031N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74N30TJFiskars Equipment Co · Saint Joseph, MIBuilt 1965 · S/N 30-762N30TLElite Approach LLC · Chesterfield, MOBuilt 2006 · S/N 172S10183N30TSAv8rs LLC · Gig Harbor, WABuilt 1994 · S/N 156N30VBGroundrush Entertainment · Beaverton, ORBuilt 2004 · S/N 10425N30VGGeoterra Inc · Eugene, ORBuilt 1980 · S/N 21063856N30VMKnott Richard C · Stony Brook, NYBuilt 1973 · S/N CE-453N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439N30WEWest Elk Air LLC · Gunnison, COBuilt 1985 · S/N 18504432N30WGMather Christopher D · Hayward, CABuilt 1974 · S/N TE-997N30WHAcme Aerosports Inc · Huntsville, ALBuilt 1977 · S/N 997-77N30WWHr Air LLC · Lakeland, FLBuilt 1994 · S/N 1N30XTBurnette Ric A · Sebastian, FLBuilt 1967 · S/N 30-1644N30YDAndre John D · Chesapeake, VABuilt 1998 · S/N 23555N30YPBmf Jax LLC · Jacksonville, FLBuilt 2012 · S/N 17281600N30ZYLewis Charles A · Winterville, NCBuilt 2024 · S/N 78109N3100Meyer Matthew D · Redding, CABuilt 1967 · S/N 491421N31006Tanner Paul L · Savoy, TXBuilt 1978 · S/N 489-HN3100BLeone James Frank · Cotulla, TXBuilt 1994 · S/N CE-1789N3100CBannon Daren · Douglass, KSBuilt 1954 · S/N 31156N3100DDiel Mark A · Walnut Creek, CABuilt 1955 · S/N 31898N3100FBurger Todd Richard · Helena, MTS/N 18257200N3100RCentral Oklahoma Aviators Flying Club · Piedmont, OKBuilt 1967 · S/N 18258500N3100SSinnissippi Aviation LLC · Beloit, WIBuilt 1964 · S/N 18255600N3100YWhalen John F · West Ossipee, NHBuilt 1962 · S/N 18254100N3101CFreefall Fever Inc · Edgewater, FLBuilt 1954 · S/N 30900
Back to AD 2007-04-19 R1