Registered aircraft · 26

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'MI' AND g.registrant_city = 'LINDEN' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'MI' AND g.registrant_city = 'LINDEN'
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'MI' AND g.registrant_city = 'LINDEN'
ORDER BY g.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.

N10628Cessna 150L · S/N 15074932Built 1973 · Warner Daniel D N12BHDehavilland DHC-1B-2-S3 · S/N 157-195Built 1956 · Munk-Ee Business Aviation LLC N1318RGrumman American Avn. AA-5 · S/N AA5-0718Built 1974 · Wright Wayne S N20170Cessna 177B · S/N 17702639Cardinal Group N2060QCessna 177RG · S/N 177RG0460Built 1973 · Alvarez Manuel B N26JGGarrett/Glasair GLASAIR SH-2R · S/N 510MRBuilt 2000 · Mckay Brian P N28690Fairchild 24W-41A · S/N W41A-111Fortin Russell J N36LLBeech A36TC · S/N EA-155Built 1980 · Beech Bums Aviation II LLC N379MBCessna 150M · S/N 15077109Built 1975 · Roeper Gary L N4011LGreat Lakes 2T-1A-2 · S/N 0825Built 1978 · Smith Jeffrey S N412CVWalters Don L RV-8 · S/N 81149Sharpe John P N421YYCessna 421C · S/N 421C0872Built 1980 · Vsa Leasing LLC N438MDPensenstadler Mark A STOL CH 750SD · S/N CH750-11246Built 2026 · Pensenstadler Mark A N44777Piper PA-28-235 · S/N 28-7510004Delisi Carl V N475WDHancook Walter D RV-6 · S/N 20195Built 1993 · Willoughby Dan J N618WDPipistrel D O O SINUS 912 · S/N 1131 SFM 912 LSABuilt 2023 · Baldwin Reid N6758UMooney M20C · S/N 2480Built 1963 · N6758u LLC N6859HCessna 172M · S/N 17265613Roeper Gary Lee N761TECessna 210M · S/N 21062498Built 1978 · Draegerweb Aviation LLC N782ABeech B95A · S/N TD-469Built 1961 · N782a Leasing LLC N7866RBeech V35A · S/N D-8926Built 1969 · N7866r Leasing LLC N901VROliver Matthew L RV-10 · S/N 40848Built 2009 · Carter Charles D N913TJCirrus Design SR22T · S/N 9036Built 2023 · Fly Happy LLC N9504TPiper PA-38-112 · S/N 38-78A0119Built 1978 · Willoughby Dan J N969QBeech B95A · S/N TD-495Built 1961 · Lindbergh Aviation LLC N981WSCessna 182S · S/N 18280328Built 1998 · Nayrmarc LLC

Back to Linden, MI