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.

N3443Registered aircraftBuilt 1978 · S/N CE-761N34430Travland Christopher L · Austin, TXBuilt 1972 · S/N 17701798N34432Wallace James K · Rio Rancho, NMBuilt 1972 · S/N 17701799N34433Sowlemann Inc · Rockton, ILBuilt 1972 · S/N 17701800N3443MBurner Dwight L · Mc Gaheysville, VABuilt 1977 · S/N 28-7890302N3443RBertrand John E · Trion, GABuilt 1967 · S/N 18258743N3443SWilliams Forest Chem LLC · Columbus, GABuilt 1964 · S/N 18255843N3443UHall George K · Cathedral City, CABuilt 1963 · S/N 18254843N3443XSaporito Timothy J · Warren, PABuilt 1966 · S/N 1131N3443YTurner Nathan D · Nenana, AKBuilt 1968 · S/N 18051943N3444Hartman James N · Bremerton, WABuilt 1965 · S/N 28-2162N34442Valenti Alan · Bend, ORBuilt 1972 · S/N 17701805N34443Schwitters Jerry · Clara City, MNS/N 17701806N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809N3444FAtwood David E Trustee · Nampa, IDBuilt 1966 · S/N 18257444N3444LDierick Greg E · Yakutat, AKS/N U206-0744N3444NPeck Justin · Forest City, PABuilt 1967 · S/N 680055N3444QKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320E0044N3444SBraha Thomas I · Mansfield, PABuilt 1964 · S/N 18255844N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744N3444ULepton Films LLC · Tarzana, CABuilt 1963 · S/N 18254844N3444XBrey Ronald P · Van, TXS/N 1132N3444ZLewanski Richard B · Sheridan, ILS/N 22-7363N34453Porcaro James · Latham, NYS/N 17701814N3445EHicks Robert C · Atkins, VABuilt 1978 · S/N 17271551N3445FAltus Aircraft LLC · Taylor, TXBuilt 1966 · S/N 18257445N3445LYama Air LLC · Granite Bay, CABuilt 1966 · S/N U206-0745N3445SBigfoot Aviation LLC · Shelton, WAS/N 18255845N3445WTrembly Alexander · Horner, WVBuilt 1965 · S/N 32-311N3446Benjamin Harold E · New York, NYBuilt 2012 · S/N 3446N34464Morgan Michael B · Stanwood, WAFirst renewal noticeBuilt 1972 · S/N 17701821N34465Brodbeck William J · Kyle, TXBuilt 1972 · S/N 17701822N34467Drust Joseph L · Menominee, MIBuilt 1972 · S/N 17701824N34469Kroll Richard L · Kalamazoo, MIBuilt 1972 · S/N 17701826N3446TR & B Air LLC · Clayton, MOBuilt 1968 · S/N 17700746N3446UTempus Morgan C · Cameron Park, CABuilt 1963 · S/N 18254846N3446XLin-Aero LLC · Conway, ARBuilt 1966 · S/N 3407N34471Grass Dennis Lee Trustee · Grass Valley, CABuilt 1972 · S/N 17701827N3447FEngh David Trustee · Wickenburg, AZBuilt 1966 · S/N 18257447N3447LHulst Damon M · Santa Barbara, CABuilt 1966 · S/N U206-0747N3447PSimonovich Sheldon K · Fredericksburg, VABuilt 1958 · S/N 23-1418N3447S182 Corp · Rockford, ILBuilt 1964 · S/N 18255847N3447TLocander Paul · Olney, MDBuilt 1968 · S/N 17700747N3447WStimart Rene D Trustee · Harshaw, WIBuilt 1965 · S/N 32-314N3447XRmm Enterprises Inc · Isabel, SDS/N 3408N34484Fingerhut Victor R Jr · Ponce, PRFirst renewal noticeBuilt 1972 · S/N 17701833N34489Plexis Management Inc · Cheyenne, WYFirst renewal noticeBuilt 1972 · S/N 17701837N3448FLarson Peter · Sheyenne, NDBuilt 1966 · S/N 18257448
Back to AD 2007-04-19 R1