Skip to content

Registered aircraft · 1,605

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2071602', '2071603')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2071602', '2071603')
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.

N89516Monks Stephen W · Limon, COBuilt 1946 · S/N 8552 N89521Spangler Taylor · Andover, KSBuilt 1946 · S/N 8557 N89523Gramann Steven G · Hartland, WIBuilt 1946 · S/N 8559 N89529Johnson Ryan · Willits, CABuilt 1946 · S/N 8565 N89535Clayton Howard N · Hartstown, PABuilt 1946 · S/N 8571 N89537Ackerman Garry · Plano, TXBuilt 1946 · S/N 8573 N89544Registered aircraftBuilt 1946 · S/N 8580 N89545Becker Phillip A · Chandler, AZS/N 8581 N89559Sperry Ralph R · Apple Valley, MNS/N 8599 N89566Hammer Donovan E · Tualatin, ORBuilt 1946 · S/N 8609 N89568Pigg James C Jr · Etna, WYBuilt 1946 · S/N 8611 N89569Gerard Bret B · Deland, FLBuilt 1946 · S/N 8612 N89572Bernard Peter C · Fleming Island, FLBuilt 1946 · S/N 8615 N89576Qualitair LLC Trustee · MichelstadtBuilt 1946 · S/N 8619 N89580Wurm Keane L · Oberlin, KSBuilt 1946 · S/N 8623 N89581Roberts Billie J · Frankfort, KYBuilt 1946 · S/N 8624 N89586Phillips James A · Lake Arrowhead, CABuilt 1946 · S/N 8629 N89592Picariello John Jr · Perkiomenville, PABuilt 1946 · S/N 8635 N89601University Of Alaska Anchorage · Anchorage, AKBuilt 1946 · S/N 8648 N89605Erggelet Sebastian · Napa, CAFirst renewal noticeBuilt 1946 · S/N 8652 N89609White Paul M · Elizaville, NYS/N 8656 N89612Johnson Lucas G · Pleasant Lake, MIBuilt 1946 · S/N 8659 N89613Registered aircraftBuilt 1946 · S/N 8660 N89616N89616 LLC · Blacklick, OHS/N 8663 N89620Womack Madie · Midlothian, TXS/N 8667 N89628Swift David R · West Ossipee, NHBuilt 1946 · S/N 8675 N89632Jrh Wings LLC · Alva, OKS/N 8679 N89633Day Britt M · Inola, OKBuilt 1946 · S/N 8680 N89636Metcalf Douglas W · San Juan Bautista, CABuilt 1946 · S/N 8683 N89641Stanley Leroy III · Little River, SCS/N 8688 N89654Classic Aeroplane Co LLC · Tucson, AZBuilt 1946 · S/N 8701 N89663Rwings LLC · Sedona, AZBuilt 1946 · S/N 8711 N89669Registration Pending · Macksville, KSRegistration pendingBuilt 1946 · S/N 8717 N89673Jensen Jake J · Bayfield, COBuilt 1946 · S/N 8721 N89674Kingsley Kiman J · Miller, MOS/N 8722 N89676Autumn Crucus LLC · Cincinnati, OHS/N 8724 N89680Evans Earl J · Oglethorpe, GABuilt 1946 · S/N 8728 N89683Ellis Keith R II · Locust Grove, GABuilt 1946 · S/N 8731 N89684Alum-I-Tank Inc · Harvard, ILBuilt 1946 · S/N 8732 N89687Allen Vincent J · Mckinney, TXBuilt 1946 · S/N 8735 N89691Johnson Warren Shane · Matheson, COBuilt 1946 · S/N 8739 N89695Rall Charles J · Mansfield, OHBuilt 1946 · S/N 8744 N89698Garrett James L · Paonia, COBuilt 1946 · S/N 8747 N89715Bolton Derwin B · Jacksonville, TXBuilt 1946 · S/N 8764 N89728Kolterjahn Garth H · Green Bay, WIBuilt 1946 · S/N 8777 N89730Brick H Paul · Pomerene, AZBuilt 1946 · S/N 8779 N89740Brons Andrew S · Newfolden, MNBuilt 1946 · S/N 8789 N89742Jones Eric A · Colfax, WABuilt 1946 · S/N 8791 N89744Mcculloch Allen W · Farmington, NMS/N 8793 N89746Russell Keith M · Ivoryton, CTBuilt 1946 · S/N 8795

Back to Cessna 140