OpenAirDocs.org
AD 88-21-07 R1

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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.

N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376N4262PPower Willis H · Weatherford, TXS/N 23-1761N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767N4276PNiec Steven M · Clio, MIBuilt 1959 · S/N 23-1775N4286PGress Gabrielle M · Davenport, FLBuilt 1959 · S/N 23-1786N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695N42PBPfister Mark A · Acworth, GABuilt 1960 · S/N 23-1895N4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeBuilt 1959 · S/N 23-1801N4302YLundstedt Gregory · Duncan, SCBuilt 1961 · S/N 23-2025N4306YRegistration Pending · Phoenix, AZRegistration pendingBuilt 1961 · S/N 23-2029N4307PGibson Kim · Ocean Springs, MSBuilt 1959 · S/N 23-1808N4309PSibille Philippe B · Waller, TXBuilt 1959 · S/N 23-1810N4310PChimera Air Inc · Maumee, OHBuilt 1959 · S/N 23-1811N4311PRitchie Glenn R · King George, VAS/N 23-1812N4312YWhittom Ron W Jr · Wasilla, AKS/N 23-2036N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619N4333PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1959 · S/N 23-1834N4334PWelke Aviation Inc · St James, MIBuilt 1959 · S/N 23-1835N4354PApache Twin Rental LLC · Harrisonville, MOBuilt 1960 · S/N 23-1854N4355PCrew Sourcing Inc · Wilmington, DES/N 23-1855N4357PWatkins Lowry Jr · Louisville, KYBuilt 1959 · S/N 23-1857N4358PQualitair LLC Trustee · MichelstadtBuilt 1959 · S/N 23-1858N4373PMartin Vernon W · Peoria Heights, ILBuilt 1960 · S/N 23-1874N4374PDodson International Parts Inc · Rantoul, KSBuilt 1960 · S/N 23-1880N4381PChase 13 LLC · Wilmington, DES/N 23-1889N43838Rodelsperger Robert · Charleston, SCS/N 27-4334N4383PBeard Michael L · Marble Hill, MOS/N 23-1893N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898N4394PJohnson Christopher R · Tulsa, OKBuilt 1960 · S/N 23-1906N4395PHesse Paul W · Oxford, NCBuilt 1960 · S/N 23-1904N4399PSchrunk Lloyd E · Canby, MNBuilt 1960 · S/N 23-1911N43CCWpb Pilot Service LLC · West Palm Beach, FLBuilt 1965 · S/N 27-2820N43HBConefry Michael A · Belle Chasse, LABuilt 1974 · S/N 27-7405379N43PTOso Air LLC · Missoula, MTS/N 27-7305217N4411PJackson James O · Lake Charles, LAS/N 23-1923N4421PAmendt Joseph J Jr · Watertown, SDBuilt 1960 · S/N 23-1935N4426YR & S Enterprises · Fort Wayne, INBuilt 1971 · S/N 27-4708N4429PRegistration Pending · Kenai, AKRegistration pendingBuilt 1960 · S/N 23-1945N4440PApac LLC · Berlin, NJBuilt 1961 · S/N 23-1957N444JKHodges Aviation LLC · Cleburne, TXBuilt 1977 · S/N 27-7854025N444VMPrecise Flights LLC · Jensen Beach, FLBuilt 1974 · S/N 27-7405320N4451PUpper Apache LLC · Titusville, FLS/N 23-1968N4452PAviation Business Corporation · Saint Louis, MOBuilt 1961 · S/N 23-1969N4457PSkyhaven Airport Inc · Tunkhannock, PABuilt 1961 · S/N 23-1974N4462PHighlands Aero Flight Center LLC · Abingdon, VABuilt 1962 · S/N 23-1983
Back to AD 88-21-07 R1