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.

N4010ZDickey Livestock Inc · Mackay, IDBuilt 1963 · S/N 18-7961N4011ASky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 30107N4011DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34711N4011EFredericks Harry III Trustee · Woodland, CAS/N 1385N4011LSmith Jeffrey S · Linden, MIBuilt 1978 · S/N 0825N4011MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2888N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059N4012DEdgren Erik J · Oskaloosa, IABuilt 1957 · S/N 34712N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963N4013Peters Joseph J · Brentwood, TNBuilt 1973 · S/N 18052326N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430N4013XN4013x LLC · Great Falls, MTS/N 5113N40141Fulton Wayne · San Luis Obispo, CAS/N 108-71N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4014XFournier Ronald A · San Diego, CAS/N 5114N4014YFogglifter LLC · Mccall, IDS/N 185-0214N4014ZAircraft Evolution LLC · Miami, FLBuilt 2025 · S/N 14862N4015AOvad David Mark · Reisterstown, MDBuilt 1970 · S/N CE-297N4015DCotten Randy · Belgrade, MTBuilt 1957 · S/N 34715N4015FCarolina Boulder And Stone LLC · Lewes, DEBuilt 2025 · S/N 14874N4015NHazel Consulting LLC · Dayton, NVBuilt 1968 · S/N 680159N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122N4016DBates Michael B · Medford, ORBuilt 1957 · S/N 34716N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002N4017P17p LLC · Caddo Mills, TXS/N 23-1492N4017SRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15031N4017Y17y LLC · Parma, IDBuilt 1961 · S/N 185-0217N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968N40189Jacob Mark K · East Lansing, MIBuilt 1943 · S/N 51218N4018DUnderhill Clinton T · Yuma, AZS/N 34718N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125N4018XCrazy Horse LLC · Princeton, WVBuilt 2025 · S/N 14881N4018ZJarosak Peter J · Valparaiso, INBuilt 1963 · S/N 18-7969N40193Rearden Logic Inc · Denver, COBuilt 1959 · S/N 24-1239N4019XBoswell Joey L · Comanche, TXBuilt 1969 · S/N 5119N4019YWitt William A · Ennis, MTBuilt 1961 · S/N 185-0219N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N401AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2020 · S/N 172S12509N401ADAlexander Brad K · Melissa, TXS/N 154-74N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401ATBlum John J · Montgomery, TXBuilt 1966 · S/N 401-0010
Back to AD 2007-04-19 R1