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.

N6312NSmith Sabra L · Danville, CABuilt 1967 · S/N 308 N6318NRiceland Aviaton Inc · Jennings, LABuilt 1967 · S/N 281 N6324NSimmons Rita B · Saint George, MEBuilt 1967 · S/N 568 N6341NDexter Fred H · Live Oak, FLBuilt 1967 · S/N 328 N6346NYoung Marlon V · Santa Rosa, CABuilt 1967 · S/N 470 N6352NGilbreath Tony C DBA · Olustee, OKBuilt 1967 · S/N 306 N6381NSutherland David D · Delta Junction, AKBuilt 1967 · S/N 451 N6382NHamptonville Aviation LLC · Hamptonville, NCBuilt 1967 · S/N 388 N6383NCarino Jane L · Buckley, WABuilt 1967 · S/N 302 N6384NWaggener Chris E · Adelanto, CABuilt 1967 · S/N 381 N6387NRobert Fuoss Inc · Draper, SDBuilt 1967 · S/N 518 N6392NPritchett Joe H · Dyersburg, TNS/N 353 N6396NChampion Aircraft LLC · Valdosta, GAS/N 355 N6397NLafleur Gregory J · Eunice, LABuilt 1967 · S/N 356 N63BCValleortiz Hector J · Laurel Hill, NCBuilt 1968 · S/N 637 N64MKCavanaugh Sean M · Ottumwa, IABuilt 1966 · S/N 434 N65AWSmith David W · Byhalia, MSBuilt 1965 · S/N 7ECA-241 N661CPSouthern Aircraft Consultnacy Inc Trustee · Casper, WYBuilt 1969 · S/N 661 N669XDiehl Steven K · Homestead, FLBuilt 1966 · S/N 68 N67KJMullahy Patrick · Burlington, IAS/N 7ECA-550 N68MEPeigneux Brothers Llp · Malta, MTBuilt 1968 · S/N 625 N697FCBlackhawk Holding Corp · Wilmington, DES/N 726-70 N71528Little John · Hamilton, TXS/N 7ECA-326 N724MSNannenga Fredrick Jr · Hillsboro, ORBuilt 1967 · S/N 298 N73PCMedearis Jeff W · Plevna, MTS/N 7ECA-48 N744JAWiebe Albert · Seminole, TXBuilt 1968 · S/N 615 N7502FBarrie Lorna D · Tonawanda, NYBuilt 1969 · S/N 713 N7503FPatton David · Elmendorf, TXBuilt 1969 · S/N 714 N7504FDerr Michael K · Maitland, MOBuilt 1969 · S/N 715 N7505FIpme Management Corp · Jefferson, GABuilt 1969 · S/N 716 N7506FOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1969 · S/N 717 N7507FThomson Mary Ellen · East Berlin, PABuilt 1969 · S/N 718 N7510FGrand Canyon Flyers LLC · Flagstaff, AZBuilt 1969 · S/N 719 N7511FEisenbrey Glen T · Greenbank, WABuilt 1969 · S/N 720 N7512FCulver Marc D · Anchorage, AKBuilt 1969 · S/N 722 N7513FFrank Jerry W · Vonore, TNBuilt 1969 · S/N 723-70 N7556FWetzel Gehred · Factoryville, PABuilt 1969 · S/N 732-70 N7560FCitabria Club LLC · Baton Rouge, LABuilt 1969 · S/N 733-70 N7569FMainero Tanner R · Chehalis, WABuilt 1969 · S/N 731-70 N7573FDirks Daniel P · Seguin, TXBuilt 1970 · S/N 757-70 N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70 N7582FCassano Graham S · Canandaigua, NYS/N 738-70 N7583FDienst Lon C · Poplar Grove, ILBuilt 1970 · S/N 739-70 N7586FJh Aviation Services LLC · Daisy, GABuilt 1970 · S/N 742-70 N7588FWilbanks Kari L · North Port, FLBuilt 1970 · S/N 751-70 N7597FKnowles Ross Martin · Chapmanville, WVS/N 743-70 N7598FDoggett Jacob R · Kingwood, TXS/N 744-70 N7599FN7599f LLC · Camarillo, CABuilt 1970 · S/N 745-70 N7602FPreston Aviation LLC · Mount Dora, FLBuilt 1970 · S/N 755-70 N7603FJacobs Robert A · Grass Valley, CABuilt 1970 · S/N 756-70

Back to Champion 7ECA