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.

N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475N167CJMunn Oliver L · Ocala, FLBuilt 2010 · S/N 25879N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500N167CSBalister Adrian G · Colorado Springs, COS/N 23197N167CWNorinsky David · Petaluma, CABuilt 2002 · S/N 1001N167GTPreferred Procurement LLC · Sheridan, WYBuilt 2001 · S/N 2007N167JMMiller James D · Wilmington, NCBuilt 2017 · S/N 071N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167LDRegistered aircraftS/N 670105N167LPSymanowski Kevin L · Reeder, NDBuilt 2001 · S/N 18281067N167MStoltzfus Jesse A · Greenfield, OHBuilt 1964 · S/N CD-795N167MSMullinax Robert A · Toccoa, GABuilt 1993 · S/N 2105N167NGohman Charles Scott · Salinas, CAS/N TE-137N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003N167QHanson John W · Stewartville, MNBuilt 2009 · S/N HC012N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514N167RVWelch Jason · Concrete, WABuilt 2016 · S/N 001N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N167SHSaratoga Aviation LLC · Wilmington, DEBuilt 2007 · S/N 11640N167SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 30064N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044N1680APaprocki Jason C · Fairplay, COS/N 20-842N1680CRogers Terrence W · Almond, WIBuilt 1953 · S/N 30380N1680GSears Richard A · Stevensville, MDBuilt 1968 · S/N 135N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512N1681CClark Eddie · Naknek, AKBuilt 1953 · S/N 30381N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725N1682CFly & Fish LLC · Kalispell, MTBuilt 1953 · S/N 30382N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513N1683CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11764N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1683WAirsouth Aviation Services Inc · Little Rock, ARS/N TC-1526N1683ZSchmitz David K · Spooner, WIBuilt 1962 · S/N 185-0483N1684CBredin William B · Anchorage, AKS/N 30384N1684GMitchell Gary N · Kansas City, KSBuilt 1968 · S/N 139N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1684WHaller Philip L · Peoria, AZS/N D-9386N1685Lane Aviation LLC · Tijeras, NMBuilt 2008 · S/N 030-53/54-704N1685CBallard Heather A · Pleasant Prairie, WIS/N 30385N1685GBrisson Gisele A · Hollister, CABuilt 1968 · S/N 194N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1686CButts Michael D · Carson City, NVBuilt 1953 · S/N 30386N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093
Back to AD 2007-04-19 R1