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.

N7148UN192ag LLC · Mckinney, TXBuilt 1964 · S/N 387 N7149UBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 388 N7151UGendrich Charles P · Middletown, CTBuilt 1964 · S/N 390 N7153USmith Coty C · The Colony, TXBuilt 1964 · S/N 392 N7155UProtze Mark · Anacortes, WABuilt 1964 · S/N 394 N7155VRansom Michael J · Camby, INBuilt 1974 · S/N 21-0050 N7157USl Motorsports Inc · Paradise Valley, AZBuilt 1964 · S/N 396 N7157VVictory David L · Toano, VABuilt 1974 · S/N 21-0052 N7158UMenjivar Christian J · Missoula, MTS/N 648 N7159UChamberlain Gary M · Challis, IDBuilt 1964 · S/N 398 N7159VCm&D Holdings Inc · Honolulu, HIBuilt 1974 · S/N 21-0054 N7176VZammit Joseph A · Riverside, CAS/N 21-0056 N7178VUhl Jack G · Bloomington, MNS/N 21-0058 N7180VFlight International Corp Trustee · Santa Ana, CABuilt 1974 · S/N 21-0060 N7184UColas Omari K · Dover, DEBuilt 1964 · S/N 402 N7186UKay David Lloyd · Virginia Beach, VABuilt 1964 · S/N 404 N7188UJones Kenyon S · Miami, FLBuilt 1964 · S/N 406 N7190QEhc Group LLC · Franklin Lakes, NJBuilt 1964 · S/N 408 N7191UDarrow Matthew J · Truckee, CABuilt 1964 · S/N 409 N7198VBrown Keane A · Portales, NMS/N 21-1162 N721HLZermeno Ira · Visalia, CAS/N 700029 N721RXLamm Donald L · Paradise Valley, AZBuilt 1970 · S/N 700060 N728WVeldman Richard D · Laporte, INS/N 766 N7424VMorgan James P · Arlington Heights, ILBuilt 1975 · S/N 21-1164 N7427VCrowe Aaron C · Hickory, NCBuilt 1975 · S/N 21-1167 N7429VMordica John E Jr · Hawk Point, MOBuilt 1975 · S/N 21-1169 N7430VViaspot Inc · Sheridan, WYBuilt 1975 · S/N 21-1170 N74PKRegistered aircraftBuilt 1974 · S/N 21-0035 N757DLRegistered aircraftBuilt 1964 · S/N 399 N757UGehret Barry · Sonoma, CABuilt 1965 · S/N 933 N75DFShelley Michael D · Murfreesboro, TNBuilt 1964 · S/N 290 N767AWTooth & Go Flyers LLC · Farmington Hills, MIBuilt 1964 · S/N 413 N767DPBeardsley William A · Tracy, CABuilt 1963 · S/N 188 N7741MScott Danny Keith · Alexander City, ALBuilt 1973 · S/N 21-0024 N7743MPatry Aeronautical Institute · Kalispell, MTBuilt 1974 · S/N 21-0025 N7745MGsh Of Alabama LLC · Huntsville, ALBuilt 1974 · S/N 21-0026 N7752MSteen Robert Z · Billings, MTBuilt 1974 · S/N 21-0028 N776NHHylton Nathaniel Dean · Pleasant Plain, OHBuilt 1965 · S/N 567 N7776MPinckney Robert L · Elgin, SCFirst renewal noticeBuilt 1974 · S/N 21-0032 N7792MSchwam Andrew M · Pullman, WABuilt 1974 · S/N 21-0037 N7793MRegistration Pending · Bloomsburg, PARegistration pendingBuilt 1974 · S/N 21-0038 N77EBBowles Alan B · Georgetown, TXBuilt 1966 · S/N 1084 N7823VNelson Brent E · Richland, WABuilt 1964 · S/N 445 N7824VLyon Timothy P · Kansas City, MOBuilt 1964 · S/N 446 N7825VHenderson Randy G · Williamstown, WVBuilt 1964 · S/N 447 N7826VUse Your Call Sign Holdings LLC · Kalispell, MTBuilt 1964 · S/N 448 N7827VJaffe Michael R · Terrell, TXBuilt 1964 · S/N 449 N7828VHam Henry P · Saint Louis, MOBuilt 1964 · S/N 450 N7829VAirdad LLC · Houston, TXBuilt 1964 · S/N 451 N7839VHafter Mark S · Cincinnati, OHBuilt 1965 · S/N 461

Back to Mooney M20E