Skip to content

Registered aircraft · 829

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 ('5870212')
  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 ('5870212')
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.

N424KCCoontz James K · Melba, IDBuilt 1964 · S/N 498 N42CPHingst Arthur · Hermann, MOBuilt 1965 · S/N 587 N435DBHigh Velocity Design Inc · Ferndale, MIBuilt 1966 · S/N 1250 N435RTBloom Mark W · Miami, FLBuilt 1965 · S/N 667 N43DHHenderson Dwight D · Cape Coral, FLBuilt 1964 · S/N 283 N4422TMooney22t LLC · Kalispell, MTS/N 305 N442MLOrlowski Micheal A · Gold Hill, NCBuilt 1966 · S/N 978 N445SPGasman401 Aviation LLC · Punta Gorda, FLBuilt 1964 · S/N 481 N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643 N480YLauschke Aviation Inc · Rapid City, SDNon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 543 N48176Lucas Bonner · Mckinney, TXBuilt 1965 · S/N 650 N488RDWhitnell Mark A · Lehigh Acres, FLBuilt 1966 · S/N 1300 N496GRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 1209 N49WWBroyles Will · Cherokee, TXS/N 558 N4MYYoung Michael D · Payson, AZBuilt 1966 · S/N 1270 N505ZRoddy Bonnie J · Holly Lake Ranch, TXBuilt 1965 · S/N 799 N50CAllred & Associates Inc · Skaneateles, NYBuilt 1965 · S/N 891 N5186YHowe Jamie W · Boynton Beach, FLS/N 690030 N523MWJoy Of Flight LLC · Kalispell, MTBuilt 1967 · S/N 670013 N527JBSoutheast Anesthesia Plc · Mcdonald, TNS/N 1243 N5502QAcademy Computer Services Inc · Stoneham, MABuilt 1965 · S/N 604 N5504QDoll Electric Co Inc · Murphys, CABuilt 1965 · S/N 605 N5508QSchmidt James A · Richmond, VABuilt 1965 · S/N 707 N5510QN407ml LLC · Wilmington, DEBuilt 1965 · S/N 608 N5514QKurtz Hans E · Clewiston, FLBuilt 1965 · S/N 610 N5520QStefanov Mark C · Georgetown, TXBuilt 1965 · S/N 613 N5522KHall Dean A · Hyattsville, MDBuilt 1965 · S/N 601 N5522QBarnhill Jerry D · Longville, LABuilt 1965 · S/N 614 N5524QImwalle John N · Batavia, OHS/N 615 N5528QCralle Family Aviation LLC · Midland, TXBuilt 1965 · S/N 617 N5534QPaul Richard W · San Jose, CABuilt 1965 · S/N 620 N5536QWokini Air LLC · Tarpon Springs, FLS/N 621 N5538QDurkee Brenton J · Brooklyn, NYBuilt 1965 · S/N 622 N5546QBrant Ryan L · Meyersdale, PAS/N 626 N5550QReal Jonathan Dan · La Jolla, CABuilt 1965 · S/N 628 N5568QJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 637 N5574QDonovan Timothy P · Wichita Falls, TXBuilt 1965 · S/N 640 N5578QLyon Scott T · Wellsville, KSBuilt 1965 · S/N 642 N5580QJohnson Kyle L · Argenta, ILBuilt 1965 · S/N 708 N55GASaathoff Michael A · Stockton, MOS/N 541 N55HQHerndon Colton R · Smithville, MOBuilt 1965 · S/N 743 N55NPN55np LLC · Broomfield, COS/N 700010 N5600QA & D Aviation LLC · Aberdeen, OHS/N 656 N5604QSkywagons.Com LLC · Placerville, CABuilt 1965 · S/N 658 N5605QBennett Steven D · La Fayette, GABuilt 1965 · S/N 759 N5610QRustad Scott K · Minot, NDBuilt 1965 · S/N 709 N5612QSrm Aviation Group LLC · Bentonville, ARBuilt 1965 · S/N 662 N5614QAltitude Aviation Services LLC · Mountain Home, IDS/N 663 N5618QHecker Clark R · Flat Rock, NCBuilt 1965 · S/N 665 N5620QMorgan Josiah B · Owasso, OKBuilt 1965 · S/N 666

Back to Mooney M20E