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.

N134HRL&P Of Mke LLC · Milwaukee, WIBuilt 1955 · S/N G-745N134JBPalfreyman Dean D · Arvada, COS/N 20999N134JCClark Julie E · Cameron Park, CAS/N G-812N134JPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1999 · S/N 170N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517N134KCKw Plastics · Troy, ALBuilt 1953 · S/N G-78N134LCConklin Lynn A · Vacaville, CABuilt 1953 · S/N 53-4149N134LMRunck Russell E · Watertown, MNBuilt 1955 · S/N G-292N134MBLarsen Matthew J · Filer, IDS/N G-83N134MCByars John Jr · Houston, ALBuilt 1997 · S/N 29-0134N134MDAa Aviation LLC · Lewes, DES/N TJ-449N134MHLa Charter And Rental LLC · New Iberia, LABuilt 2013 · S/N 30055CN134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483N134MMGrace John M · Wickenburg, AZBuilt 1956 · S/N BG-299N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593N134NMPatrick Brent · Brunswick, GABuilt 2011 · S/N 90134N134PJHelibro LLC · Red Bluff, CABuilt 2002 · S/N 172S9187N134PSBountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.407N134RDDevere Albert R · Warrenton, VABuilt 1955 · S/N BG-11N134RRRussell Jon D · Calabasas, CABuilt 1957 · S/N BG-340N134RSRosborough Todd D · Medford, ORBuilt 1986 · S/N 49N134RTTaylor Robert E · Soldotna, AKBuilt 2017 · S/N 78N134SFReid Brian S · Merced, CABuilt 1965 · S/N 28-20994N134SMCzech Six LLC · Lafayette, LABuilt 1957 · S/N BG-312N134TDDonovan Gary L · Lake City, FLBuilt 1955 · S/N BG-79N134TFSpectre Aviation LLC · Exeter, NHBuilt 1993 · S/N CE-1764N134TTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N G-305N134TXExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1953 · S/N G-113N134VPColclazer John F Jr · Flagstaff, AZBuilt 1965 · S/N 28-21108N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191N134WDRoorda Thomas D · Port Angeles, WABuilt 1996 · S/N 20921N134WSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 28020137N134YMentor Aviation LLC · Viera, FLS/N 140908N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168N13504Brewer Ruthie C · Wendell, NCBuilt 1973 · S/N 17262801N13506Asberry Gregg · Sidney, ARBuilt 1973 · S/N 17262803N13507Torell Pamela O · Port St Lucie, FLBuilt 1973 · S/N 17262804N13508Labrador Aviation LLC · Barboursville, VABuilt 1973 · S/N 17262805N1350JFish Associates Inc Trustee · Wilmington, DEBuilt 1976 · S/N 516N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868N1350UCain Ronald August · Slidell, TXS/N 248N1350WMaxwell Don P · Longview, TXS/N 2631N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430N13513Stella Luna Aviation LLC · Olive Branch, MSBuilt 1973 · S/N 17262810N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708N1351EJ & S Air Ventures LLC · Eagle Lake, FLBuilt 1978 · S/N 17270965N1351G310 LLC · Conover, NCBuilt 1976 · S/N 310R0708N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21N1351SEllard James M · Danielsville, GABuilt 1976 · S/N 18264914
Back to AD 2007-04-19 R1