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.

N551BWarbirds Of The World Air Museum · Los Lunas, NMBuilt 1948 · S/N SV113-D-1569N551BBMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881574N551BGOne Bravo Gulf LLC · Lutz, FLBuilt 1973 · S/N 18262018N551BKCedar Ridge Aviation LLC · Knox City, TXBuilt 2008 · S/N 12197N551BW602 Xx LLC · Springdale, ARBuilt 1990 · S/N CE-1431N551CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881513N551CDBwr Group LLC · Hobbs, NMBuilt 2005 · S/N 1550N551CMKeller Charles L · Henderson, NVBuilt 1999 · S/N 2014N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158N551DSFreeburg Farms Inc · Worley, IDBuilt 1955 · S/N 31289N551ERSunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10548N551ESNimno 551es LLC · Pompano Beach, FLBuilt 2005 · S/N 172S9902N551GJanes Christopher D · Columbia, KYBuilt 1968 · S/N D-8772N551JACalderon Gustave P · Carlsbad, CABuilt 1978 · S/N E 1424N551JBValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 21061129N551JHN551jh Sky Holdings LLC · Grand Ledge, MIBuilt 1975 · S/N 28-7525185N551JSEm Concepts LLC · Cape Coral, FLBuilt 1978 · S/N TC-2199N551LAHamlin Co · Long Beach, CABuilt 2006 · S/N 11241N551MPKlesel Cameron S · Schulenburg, TXBuilt 2005 · S/N 23375N551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeBuilt 2008 · S/N 172S10858N551PASkowbo Rock G · Jacksonville, FLS/N 28-7225472N551PGChavi LLC · Fredericksburg, TXBuilt 1978 · S/N 17271384N551PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842088N551SFFilmlites Montana LLC · Bozeman, MTBuilt 1980 · S/N 18267603N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013N551TSAbc Air Inc · Eveleth, MNBuilt 1968 · S/N 18259381N551TXCarrozza Louis R · Haymarket, VABuilt 2000 · S/N MII1984N551USFar Side Aero LLC · Santa Maria, CABuilt 2005 · S/N 29-0351N551ZLGlascock Devin Duwaine · Clovis, NMS/N 3RX025N55200Skyhawk Flyer LLC · Monticello, IABuilt 1981 · S/N 17275134N55203Mil2atp Inc · Pikeville, NCBuilt 1973 · S/N 28-7325342N55206Shipman Mark J · Nellysford, VABuilt 1973 · S/N 28-7305333N5520DSwaeringen Eric · Snohomish, WABuilt 1979 · S/N 17272591N5520FChicago Air LLC · Chicago, ILS/N 28-24862N5520KHillstrom Rudolph A · Oakville, WABuilt 1978 · S/N 385-78N5520NChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11400N5520POdonnell Nathan Ray · Enterprise, ALBuilt 1958 · S/N 24-583N5520QStefanov Mark C · Georgetown, TXBuilt 1965 · S/N 613N5520SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11399N5520UChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11398N5520XUS Aviation Training Solutions Inc · Titusville, FLBuilt 2014 · S/N 172S11405N55211Skylens LLC · Hammond, LABuilt 1981 · S/N 17275135N55214N55214 LLC · Celina, TXBuilt 1973 · S/N 28-7305334N55215Zarama Jose · Easley, SCBuilt 1973 · S/N 28-7305335N55216Huizar Victor · Albuquerque, NMBuilt 1973 · S/N 28-7305336N55218Christiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11424N55219Wilkinson Thomas W · Weyers Cave, VABuilt 1973 · S/N 28-7305337N5521BHunt Nicholas R · Bozeman, MTBuilt 1956 · S/N 33521N5521FMarc Inc · Brandon, MSFirst renewal noticeBuilt 1968 · S/N 28-24863N5521JVanrider Jeffrey F · Wildwood, FLBuilt 1967 · S/N 32-958
Back to AD 2007-04-19 R1