OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N14226Lathem Douglas · Dalhart, TXBuilt 1974 · S/N 18-7409099N1422CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12894N1422DBlack Bird Leasing LLC · Wilmington, DEBuilt 2006 · S/N 11450N1422EA S Air LLC · Lantana, FLBuilt 1978 · S/N 17270991N1422JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13175N1422XDt'S Aviation LLC · Garden City, KSBuilt 1975 · S/N 28-7525287N1423GHolscher Barclay M · Amery, WIBuilt 1962 · S/N CD-447N1423JSandyland LLC · Madison, FLBuilt 1975 · S/N 423N1423TWaggoner Kevin M · Donnellson, IABuilt 1972 · S/N 28-7225509N1423UPatkotak Crawford Ahkivgak · Barrow, AKBuilt 1976 · S/N 17267090N1423XFigueroa Rafael A Jr · Coulterville, CABuilt 1975 · S/N 28-7515317N1423ZVan Buskirk Bill J · Wasilla, AKBuilt 1952 · S/N 18-1924N1424CGlendoe Inc Trustee · Wilmington, DEBuilt 2005 · S/N 18281610N1424EFamily Rec Corp · Marysville, KSBuilt 1978 · S/N 17270993N1424GLothlorien LLC · Two Harbors, MNBuilt 1961 · S/N CD-445N1424JDuwelius Sue DBA · Hermiston, ORBuilt 1975 · S/N 424N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043N1424TFoster Adam J · Houston, TXBuilt 1972 · S/N 28-7225511N1424UCavern City Flight School LLC · Carlsbad, NMBuilt 1976 · S/N 17267091N1424VRtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263569N1424XLewis Keith W · Clearwater, FLBuilt 1975 · S/N 28-7515318N14255J T Howell And Son LLC · Jackson, LABuilt 1974 · S/N 18-7409058N1425KTopaircraft Classic Wings Holding LLC · Eureka, MOS/N 10153N1425TSkydance Aviation LLC · Norfolk, VABuilt 1972 · S/N 28R-7235286N1425XHowell Joshua · El Cajon, CABuilt 1975 · S/N 28-7515319N14269Andersen Roger · Curtis, NEBuilt 1974 · S/N 18-7409059N1426JKvistad Charles O · Granite Falls, MNBuilt 1975 · S/N 426N1426MKing Corbin B · Lubbock, TXS/N 18264324N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038N1426ULegried Brian K · Longville, MNBuilt 1976 · S/N 17267093N1426XBair Preston W Jr · Coshocton, OHBuilt 1975 · S/N 28-7515321N1427GCarter Geoffrey R · Ormond Beach, FLBuilt 1962 · S/N D-6903N1427XAlis Aquilae LLC · Opelika, ALBuilt 1975 · S/N 28-7515402N14281Technical Education Services Inc T/A · Virginia Beach, VABuilt 1972 · S/N 27-4843N1428JLeedham James E DBA · Mazeppa, MNBuilt 1966 · S/N 28-3539N1428MBaja Air LLC · Wilmington, DEBuilt 1975 · S/N 18264326N1428UKops Kenneth M · East Helena, MTBuilt 1976 · S/N 17267095N1428VBreitenbucher Paul W · Lodi, CABuilt 1975 · S/N 17264687N14297Barrett Eric W · Cherry Hill, NJBuilt 2005 · S/N 18281715N14298Campbell Kenneth D · Soldotna, AKBuilt 1974 · S/N 18-7409062N14299Compton John D · Morgan, UTBuilt 1974 · S/N 18-7409064N1429ESullins David A · Santa Barbara, CABuilt 1978 · S/N 17270996N1429XRegistered aircraftBuilt 1975 · S/N 28R-7535278N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92N142ASGray William Colin · Seattle, WABuilt 1966 · S/N 28-22530N142AVStraight Up Leasing Inc · Medford, ORBuilt 2024 · S/N 14776N142BLipinski Glen E · Chandler, AZBuilt 1992 · S/N 10134N142BESugar Pop Group LLC · Saco, MEBuilt 2001 · S/N 14103CN142BSChristian Tax Advisors LLC · Houston, TXBuilt 2005 · S/N 172S9881N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161
Back to AD 2007-04-19 R1