Skip to content

Registered aircraft · 420

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

N7779JLehrkamp Mike C · Caputa, SDBuilt 1966 · S/N 536 N8038WMctaggart Briar C · Adelanto, CAS/N 179 N82682Long Jory J · Lake Ozark, MOBuilt 1970 · S/N 772-70 N82VBSky Designs LLC · Kalamazoo, MIBuilt 1967 · S/N 491 N8302VStrange Beasts LLC · Chicago, ILBuilt 1966 · S/N 414 N8306VJones Richard E · Cody, WYBuilt 1966 · S/N 244 N8307VFowler Steve · Washington, INS/N 465 N8312VPester Mark C · Crookston, MNBuilt 1966 · S/N 458 N8313VMedlin Wayne D · Marshville, NCBuilt 1966 · S/N 53 N8315VReynolds Eric F · Princeton, MNBuilt 1966 · S/N 481 N8331VAirplane Binnis LLC · Janesville, WIBuilt 1966 · S/N 477 N8334VRegistration Pending · Milton, FLRegistration pendingBuilt 1966 · S/N 482 N8335VLisoski Derek L · Clark Fork, IDBuilt 1966 · S/N 474 N8337VWydronek Joseph A · Tucson, AZBuilt 1966 · S/N 422 N8338VGustafson Cody A · Corvallis, ORBuilt 1966 · S/N 401 N8342VPrecision Aerial Ag LLC · Seneca, KSS/N 232 N8350VMertz Rachel A · New Ulm, MNFirst renewal noticeBuilt 1966 · S/N 85 N8353VN8353v LLC · Monroe, LAS/N 294 N8356VGroh David A · Mason, MIBuilt 1966 · S/N 478 N8359VCressman Scott M · Mount Pleasant, TXBuilt 1966 · S/N 412 N8369VCentral Virginia Aviation Inc · N Dinwiddie, VAS/N 468 N8372VVarwig Korrey L · Peoria, ILBuilt 1966 · S/N 432 N8374VDexter Fred M · Live Oak, FLS/N 449 N8375VCarll Elizabeth M · Chicago, ILBuilt 1966 · S/N 505 N8376VKirkeby Dean A · Clark, SDBuilt 1966 · S/N 80 N8377VWeber William A · Brodhead, WIBuilt 1966 · S/N 280 N8378VDollins Carl E · Grosse Ile, MIBuilt 1966 · S/N 486 N8387VN8387v LLC · Lansing, MIBuilt 1966 · S/N 507 N8389VNelzen Wayne K · Mulino, ORBuilt 1966 · S/N 529 N8390VMapel Roger N · Weirton, WVBuilt 1966 · S/N 537 N8395VVandeman Jack A · Norco, CABuilt 1966 · S/N 530 N85MLEscott Aerial Spraying LLC · El Reno, OKBuilt 1965 · S/N 7ECA-277 N87WRJohnston Donald C · Davis, CABuilt 1967 · S/N 520 N8DBBaker Drew A · Little Rock, ARBuilt 1966 · S/N 402 N9009LSale Reported · Fairbanks, AKSale reported, pending cancellationBuilt 1970 · S/N 754-70 N9022LSedeyn Beth G · Salem, NJBuilt 1970 · S/N 749-70 N9024LVine Grove Airport Inc · Vine Grove, KYBuilt 1970 · S/N 758-70 N9025LMcmillan Custom Service Inc · Ulmer, SCBuilt 1970 · S/N 759-70 N9039LBowman Eagles Inc · Louisville, KYBuilt 1970 · S/N 767-70 N9049LOsborn Melissa L · Fairbanks, AKBuilt 1970 · S/N 764-70 N9050LOwen Alva A · Hilliard, FLBuilt 1970 · S/N 765-70 N9057LKing Nathan A · Dunkirk, MDS/N 769-70 N9066LPasco Gary R · Brockport, NYBuilt 1970 · S/N 773-70 N9067LGabriel Thomas G · Clinton, PABuilt 1970 · S/N 774-70 N9073LRegistration Pending · Munford, TNRegistration pendingBuilt 1970 · S/N 776-70 N9074LTillotson Bradley T · Loveland, OHBuilt 1970 · S/N 777-70 N9075LSibbernsen William · Omaha, NEBuilt 1970 · S/N 778-70 N9082LSmethurst Jeffrey C · San Francisco, CABuilt 1970 · S/N 781-70 N9087LDeterding Jim L · Pond Creek, OKS/N 783-70 N9088LLegends LLC · Willow, AKBuilt 1970 · S/N 782-70

Back to Champion 7ECA