Skip to content

Registered aircraft · 3,118

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:82-23-01-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:82-23-01-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:82-23-01-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:82-23-01-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:82-23-01-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:82-23-01-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.

N661SDDarr Henry S · High Point, NCBuilt 1965 · S/N 24-4354 N6621PR C Antique Aviation LLC · Saint Louis, MOBuilt 1960 · S/N 24-1742 N6623PHopkins Daryl L · Gentry, ARBuilt 1959 · S/N 24-1744 N6624PMiller David J · Washington, IABuilt 1960 · S/N 24-1746 N6627PMaddela Prabhuvaram J · El Mirage, AZBuilt 1959 · S/N 24-1750 N6630PSumners Toby · Aurora, MOBuilt 1960 · S/N 24-1753 N6633PSkinner Norman D · Osceola, IABuilt 1959 · S/N 24-1756 N6635PJohnston Robert J · Oro Valley, AZBuilt 1960 · S/N 24-1757 N6637PEbner Rudy · Orange, TXBuilt 1960 · S/N 24-1759 N6639PMustain Michael J · Monticello, GABuilt 1960 · S/N 24-1761 N6640PAlexander Paul S · Selma, ALBuilt 1959 · S/N 24-1762 N6641PMartinous Shawn A · Providence, RIBuilt 1960 · S/N 24-1763 N6648PAnkrom Lloyd Paul · Manasquan, NJBuilt 1960 · S/N 24-1770 N6650PAnderson Gregory · Acworth, GABuilt 1960 · S/N 24-1773 N6652PKlapstein Nancy M · Sweet Grass, MTNon-citizen corporation, flight hours not reportedS/N 24-1775 N6654PBaldwin Gary S · Prescott, AZBuilt 1960 · S/N 24-1777 N6656PGregory James A · East Burke, VTBuilt 1960 · S/N 24-1779 N6657PMiller Aaron M · Scottsdale, AZBuilt 1960 · S/N 24-1780 N6658PParrish Troy Don · Tokio, TXBuilt 1960 · S/N 24-1781 N6659PKrochmal David Ryan · Lancaster, PABuilt 1960 · S/N 24-1782 N6665PForee Rick DBA Foree Aviation · Midlothian, TXBuilt 1960 · S/N 24-1789 N6667PKinder Billy Dale · Black Rock, ARBuilt 1960 · S/N 24-1791 N666KHMks Aviation Of Mt Airy LLC · Mount Airy, NCBuilt 1972 · S/N 24-5026 N6672PWorkman William R · Tipp City, OHS/N 24-1796 N6673PHelldorfer Thomas J · Placerville, CABuilt 1960 · S/N 24-1797 N6679PJmj Aviation LLC · Kalispell, MTBuilt 1960 · S/N 24-1803 N6680PWilliams Aaron J · Addison, TXBuilt 1960 · S/N 24-1783 N6681PHouse Charles D · Tunkhannock, PABuilt 1960 · S/N 24-1805 N6684PN6684p LLC · Kalispell, MTBuilt 1960 · S/N 24-1808 N6687PShuster Kert · Lanai City, HIBuilt 1960 · S/N 24-1811 N6688PGarner Charlotte Trustee · Sun Lakes, AZS/N 241525 N6689PQuintero Noel · Fontana, CABuilt 1960 · S/N 24-1812 N6697PTri County Air Courier LLC · Prosper, TXBuilt 1960 · S/N 24-1822 N669PBluhm Daniel A · Gold Hill, ORBuilt 1966 · S/N 24-4507 N6701PHammond Craig D · Lawton, OKBuilt 1960 · S/N 24-1827 N6702PWakefield Robert M · Winnemucca, NVBuilt 1960 · S/N 24-1828 N6706PHadley George M · Boston, MABuilt 1960 · S/N 24-1832 N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835 N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053 N6710POdell Jeffrey S · Roseville, CABuilt 1960 · S/N 24-1836 N6711PPietroburgo Stephen M · Colville, WABuilt 1960 · S/N 24-1837 N6715PFrancis Investment Corp · Tulsa, OKBuilt 1960 · S/N 24-1841 N6718POmalley Wendy · Alameda, CABuilt 1960 · S/N 24-1844 N6720PWhipple Daniel · Oklahoma City, OKBuilt 1960 · S/N 24-1847 N6723PNapoliello Kent · Boca Raton, FLBuilt 1960 · S/N 24-1850 N6729PDarr Henry H · Drummond, MTBuilt 1960 · S/N 24-1856 N6730PShea Kelly P · Providence, RIBuilt 1960 · S/N 24-1857 N6731PMeadlin Melvin Mathew II · Thornton, COBuilt 1960 · S/N 24-1858 N6734PMaedl Marcus · Vista, CABuilt 1960 · S/N 24-1861 N6737PEhni Scott M · Trinity, TXBuilt 1960 · S/N 24-1865

Back to AD 82-23-01 R1