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.

N1639WElt Services LLC · Wilmington, DEBuilt 1972 · S/N CD-1295N163AMRogers Brian D · Pacific, MOBuilt 1968 · S/N 28-5009N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061N163BCClear Skies Aviation Inc · Hayward, CABuilt 2004 · S/N 1370-2004N163BDPlanenutts LLC · Tulsa, OKBuilt 1991 · S/N 1N163CMRegistered aircraftBuilt 2010 · S/N 22787N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492N163CTRenson Travel LLC · San Antonio, TXBuilt 2016 · S/N 18282390N163DHGilbert Jeffrey R · Dahlonega, GABuilt 2012 · S/N 11459N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469N163HJ&L Asset Holdings LLC · Biloxi, MSBuilt 1957 · S/N 34049N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715N163LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842362N163MABlue Dawg LLC · Sandpoint, IDBuilt 2005 · S/N 2303N163MMJ & L Avstar Corp · Paducah, KYBuilt 1993 · S/N 27-0163N163QGofly Trading LLC · Opa Locka, FLBuilt 1964 · S/N TC-671N163RDRegistration Pending · Pass Christian, MSRegistration pendingBuilt 2000 · S/N 22088N163RKGardner Michael John · Ashland, ILBuilt 2006 · S/N 11120N163SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4175N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872N163SRRegistration Pending · Helena, MTRegistration pendingBuilt 1989 · S/N 163N163SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14730N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98N163YStick And Rudder Aviation LLC · Afton, WYBuilt 2018 · S/N 10443N16402Peters Dale M · Naknek, AKBuilt 1973 · S/N 28-7305245N16409Pridmore Joshua B · Lubbock, TXBuilt 1973 · S/N 28-7325265N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078N1640GTownsend Gary V · Sunderland, VTS/N 116N16410Cherokee Five LLC · Bakersfield, CABuilt 1973 · S/N 28-7325266N16412Cherokee N16412 LLC · Peoria, AZBuilt 1973 · S/N 28-7305247N16417Riddle Christopher Joseph · Auburn, CABuilt 1973 · S/N 28-7305249N16418Hallgren Mitchel T · Sycamore, ILBuilt 1973 · S/N 28-7305250N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145N16425Box Aviation Inc · Montgomery, ALBuilt 1973 · S/N 28-7305251N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112N1642GLetourneau University · Longview, TXBuilt 1969 · S/N 169N1642PBangerter Timothy W · Leoti, KSBuilt 1954 · S/N 22-2458N1643Elias Bernard J · Hampton, GABuilt 1982 · S/N 3008N16430Lyons Larry A · Stockton, ILBuilt 1973 · S/N 28-7305252N16433Pn4 Aviation Holdings LLC · Bishop, CABuilt 1973 · S/N 28-7325271N16434Livingston Charles · Franklinville, NYS/N 28-7325273N16435Gumms Leroy J · Perris, CAS/N 28-7305254N16437Novawings Aviation LLC · Porter, TXS/N 28R-7335146N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643N1643HSiegenthaler Dean · Mineral Point, WIBuilt 1977 · S/N 32-7700011N1643JDe Bry Daniel G · Dowagiac, MIS/N 28-24034N1643PPacer Air LLC · Wilmington, OHBuilt 1954 · S/N 22-2459N1643TWilliams Rudder · Scottsboro, ALBuilt 1965 · S/N CD-989
Back to AD 2007-04-19 R1