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.

N452Chace Stephen B · Bloomington, ILBuilt 1986 · S/N 632N45204Markelov Sergey · Naperville, ILBuilt 1979 · S/N AA5B1067N45208Bunker Wayne M · Cape Carteret, NCBuilt 1979 · S/N AA5B1069N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060N4520FRegistered aircraftBuilt 1966 · S/N 185-1005N4520JRegistered aircraftBuilt 1968 · S/N 28R-30377N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063N4520RBurge John A · Pensacola, FLS/N 28-21222N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216N4520XFlorida Coast To Coast Helicopters Inc · Pompano Beach, FLBuilt 2009 · S/N 12873N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077N4521BWitthaus James K Jr · Anchorage, AKBuilt 1955 · S/N 31420N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071N4521JSpringer Louis A · Bellflower, CAS/N 28R-30378N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223N4521TSpencer Kevin L DBA · Bend, ORBuilt 1972 · S/N 28R-7235077N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089N4522ABryant Stephen · Anchorage, AKS/N 22-3829N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085N4522SSpecialty Surgery Centers Of America Inc · Brentwood, TNBuilt 1975 · S/N TC-1889N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091N4523JN4523j LLC · Wilmington, DEBuilt 1968 · S/N 28R-30381N4523RGardner Michael J · Ashland, ILS/N 28-21225N4523SLucky92 & Associates LLC · Reno, NVBuilt 1976 · S/N TE-1062N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112N45249Porus Joseph B · Oakland, NJBuilt 1979 · S/N AA5B1115N4524BBarbero Matias J · Cape Coral, FLBuilt 1979 · S/N AA5B1098N4524EHarper Michael B · Buena Vista, COBuilt 1979 · S/N AA5B1099N4524KMorris David R · Montara, CABuilt 1979 · S/N AA5B1100N4524NHorejsi Michael E · Castro Valley, CABuilt 1979 · S/N AA5B1103N4524PRegistered aircraftBuilt 1979 · S/N AA5B1105N4524QRegistered aircraftBuilt 1979 · S/N AA5B1106N4524SKnox James P · Park Rapids, MNBuilt 1975 · S/N E-727N4524WRichardson Shane D · Pekin, ILBuilt 1979 · S/N AA5B1109
Back to AD 2007-04-19 R1