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.

N4492AMerkes Dennis R · Soldotna, AKBuilt 1956 · S/N 18-4861N4492JJohnson Richard E · Waynesboro, MSBuilt 1980 · S/N TH-1199N4492SD K Boyer LLC · Melbourne, FLBuilt 1975 · S/N E-710N44931H&R Aircraft Co LLC · Ward, ARBuilt 1977 · S/N 28-7816046N4493FMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7715041N4493JBrown Henry T · Cairo, GABuilt 1967 · S/N 28-22911N4493RBarnstormers Inc · Bemidji, MNBuilt 1974 · S/N 17263235N4493SRudrud David O Trustee · Scottsdale, AZBuilt 1975 · S/N D-9792N4493XStott Mark L · Fairbanks, AKBuilt 2010 · S/N 12785N4493ZGates Mary Jill · Anchorage, AKFirst renewal noticeBuilt 1969 · S/N 18-8847N44944Karimi Enterprises LLC · Myrtle Beach, SCBuilt 1977 · S/N 32-7740113N44949Shoreline Aviation Inc · Marshfield, MABuilt 1977 · S/N 28-7816050N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815N4494JAldrich Matthew H · Corinth, TXBuilt 1967 · S/N 28-22913N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016N4494SLayer Scott E · Palm Harbor, FLBuilt 1975 · S/N E-709N4494WConlon James E Jr · Troy, NYBuilt 1974 · S/N D-9614N4494YBegrow Adroaldo D · Gulf Shores, ALBuilt 1966 · S/N 25-4161N4494ZKasemodel Alan D · Billings, MTBuilt 1969 · S/N 18-8848N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034N4495KCrawford William A · Batavia, OHBuilt 1948 · S/N NAV-4-1495N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011N4496QWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1972 · S/N 18800896N4496SHme Holdings Group LLC · Franklin, INBuilt 1975 · S/N D-9793N4496XJennings Matthew · Valley Center, CAS/N 28-7690022N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869N4497FMurray David J · Waymart, PABuilt 1976 · S/N 28R-7635412N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239N4497SFrazier Ford P · Oakland, CABuilt 1975 · S/N CE-592N4497TArrow97t Llp · Feeding Hills, MABuilt 1972 · S/N 28R-7235042N4497VMiller Kale Michael · Mountain Home, TXBuilt 2011 · S/N 13083N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023N44980Evans Jeffrey T · Hannibal, MOBuilt 1980 · S/N E-1658N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919N4498SHaskins Scott · Spring Hill, KSBuilt 1975 · S/N E-714N4498TCunniff Jack S · Weymouth, MAFirst renewal noticeBuilt 1972 · S/N 28R-7235045N4499Southern Utah University · Cedar City, UTBuilt 2020 · S/N 14430N44990Fineran James V III · Towson, MDBuilt 1977 · S/N 32-7840002N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054
Back to AD 2007-04-19 R1