Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N6618PChurchill John C · Parker, AZBuilt 1960 · S/N 24-1739 N6619PRatliff Byron L · Paragould, ARBuilt 1960 · S/N 24-1740 N661DCParts Catalog Holding LLC · Clearwater, FLBuilt 1977 · S/N 28R-7703244 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, IAFirst renewal noticeBuilt 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 N6631FYah Inc · Wilmington, DEBuilt 1976 · S/N 32R-7780033 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 N66CSWolf Steven T · De Graff, OHBuilt 1973 · S/N 28R7335107 N66JJWilliams Nicholas Indrais · Pickerington, OHBuilt 1972 · S/N 28R-7235157 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 N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035 N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835 N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053 N670XBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 2844055 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

Back to AD 97-01-01 R1