Skip to content

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

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:80-26-04-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:80-26-04-R1') ORDER BY n_number

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:80-26-04-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:80-26-04-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.

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:80-26-04-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:80-26-04-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

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

Back to AD 80-26-04 R1