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.

N4940ASims Charles A · Chugiak, AKBuilt 1956 · S/N 32337N4940DAirborne One LLC · Kalispell, MTS/N 51040N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681N4940FJackson Christopher M · Clearwater, FLBuilt 1976 · S/N 28R-7635445N4940GN4940g LLC · Portsmouth, NHS/N 17273487N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376N4940LDrown William K · Columbus, OHS/N 28-4310N4940NWray James R Jr · Brighton, COBuilt 1979 · S/N 18267465N4940PArpey Aviation Ltd · Colleyville, TXBuilt 1963 · S/N 27-535N4940SO'Gorman Robert W Jr · Wake Forest, NCBuilt 1980 · S/N R18201479N4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842228N4940WKitt Consulting LLC · Boardman, OHBuilt 1977 · S/N 14262N4941AMartinello Domenic · Clarksville, TNBuilt 1978 · S/N 310R1407N4941VClark Robert J · Brookshire, TXS/N 30146N4942AChapman Peter E · Placerville, CABuilt 1956 · S/N 32339N4942DN4942d LLC · Greenfield, NHBuilt 1958 · S/N 51042N4942PSchulz Beverly A · Merrill, WIBuilt 1963 · S/N 27-537N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642N49434943 LLC · Kalispell, MTBuilt 2014 · S/N 4311N4943EPettit Robert · Carnegie, OKS/N 18503914N4944CCoke Richard · Bedford, TXS/N BG-283N4944DSelkirk Associates Inc · Wilmington, DEBuilt 1958 · S/N 51044N4944LWilson Zane D · Fairbanks, AKBuilt 1967 · S/N 28-4313N4944PReed John Richard · Charleston, ILBuilt 1964 · S/N 18255703N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461TN4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483N4945AIverson Randy · Winnemucca, NVBuilt 1956 · S/N 32342N4945CFandango Ranch Operating Co Inc · Bend, ORS/N BG-234N4945FEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2002 · S/N 10015N4945JAsher Academy · Cameron, TXS/N 28R-30692N4945LAlahmadi Hussein I · Avon, CTS/N 28-4314N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4945WBlueline Flight Systems LLC · Orlando, FLBuilt 1977 · S/N 14267N4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeBuilt 1979 · S/N 18503916N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378N4946LAndrews University · Berrien Springs, MIBuilt 1967 · S/N 28-4315N4946TElite Fleet Jacksonville LLC · Jacksonville, FLS/N 28-7225286N4946VJennings Carl M · Au Gres, MIS/N 30148N4947AGleiter David W · Overland Park, KSBuilt 1956 · S/N 32344N4947DEnstrom Thomas · New Berlin, NYBuilt 1958 · S/N 51047N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494N4947JElite Fleet LLC · Spofford, NHBuilt 1968 · S/N 28R-30694N4947LAmoth Dallas V · Bonners Ferry, IDBuilt 1967 · S/N 28-4316N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682TN4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486N4947WBloom Kevin Lynn · Freeport, FLBuilt 1977 · S/N 14269N4948Andersen Bret E · Chugiak, AKBuilt 1969 · S/N 18-8745N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4948CRobillard Ross · Eveleth, MNBuilt 1975 · S/N 18502664N4948DSobrado Victor M · Norman, OKBuilt 1958 · S/N 51048
Back to AD 2007-04-19 R1