Skip to content

Registered aircraft · 1,565

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

N4833NMegalith LLC · Belvidere, ILS/N 18267403 N4837NTres Bros LLC · Arcata, CAS/N 18267407 N4841NHall & Harberts LLC · Grove City, OHBuilt 1979 · S/N 18267411 N4844NTurbyfill Tony L · Vina, ALBuilt 1979 · S/N 18267414 N4868NWisner David · East Hampton, NYBuilt 1979 · S/N 18267425 N4869NBlack Hawk Brothers LLC · Lakeland, FLBuilt 1979 · S/N 18267426 N4880NFront Porch Air LLC · Dalton, GABuilt 1979 · S/N 18267432 N4882NCreative Strategies Inc · Proctorville, OHBuilt 1979 · S/N 18267434 N4884NCure Louie M · Granbury, TXBuilt 1979 · S/N 18267436 N4886NMartin Barry W Trustee · San Diego, CAS/N 18267438 N4903NDroke Paul Dan Jr · Coalgate, OKBuilt 1979 · S/N 18267447 N4906NKmq Data Acquisitions LLC · Chugiak, AKBuilt 1979 · S/N 18267450 N4917NHanging On The Prop LLC · San Tan Valley, AZBuilt 1979 · S/N 18267454 N4919NKoffeman Edward · Midlothian, TXBuilt 1979 · S/N 18267455 N4927NRmst LLC · Mason, OHBuilt 1979 · S/N 18267457 N4932NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1979 · S/N 18267460 N4936NSwett Alan · Panora, IABuilt 1979 · S/N 18267463 N4940NWray James R Jr · Brighton, COBuilt 1979 · S/N 18267465 N4949NCompass Rose Aviation · Derby, KSBuilt 1979 · S/N 18267474 N4951NCactus Av8rs LLC · Gilbert, AZBuilt 1979 · S/N 18267476 N4956NCosta Luiz A · Fort Myers, FLBuilt 1980 · S/N 18267480 N4957NRegistered aircraftS/N 18267481 N4963NHarrison Earl S · Clarksville, TNBuilt 1979 · S/N 18267485 N4965NDowner Michael · Scottsdale, AZBuilt 1979 · S/N 18267487 N4968NConfarotta Todd A · Mount Pleasant, SCBuilt 1979 · S/N 18267489 N4969NGreen Michael P · Thomaston, CTBuilt 1979 · S/N 18267490 N4972NEllis Michael J · East Wenatchee, WABuilt 1979 · S/N 18267493 N4974NCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18267495 N4975NRegistered aircraftBuilt 1979 · S/N 18267496 N4976NMerlin Aviation LLC · Palisade, COBuilt 1979 · S/N 18267497 N4993NBryant Kenneth D · Black Diamond, WABuilt 1980 · S/N 18267461 N4MWTl Aviation LLC · Jonesboro, ARBuilt 1977 · S/N 18265661 N4URN4ur LLC · Comanche, TXBuilt 1977 · S/N 18265940 N4WQKittinger Aviation LLC · Calhoun, KYBuilt 1977 · S/N 18266216 N4YTMclaren Paul E · Pensacola, FLBuilt 1979 · S/N 18267185 N4YVDonnie Young Farms Inc · Ulysses, KSBuilt 1977 · S/N 18266043 N501ACNka Inc · Wilmington, DEBuilt 1979 · S/N 18266922 N5083NN5083 LLC · San Diego, CABuilt 1979 · S/N 18267504 N5086NSnoopy Aviation Ltd · San Antonio, TXBuilt 1979 · S/N 18267505 N5089V89v LLC · Bethlehem, PABuilt 1980 · S/N 18267506 N5097NDevericks Richard · Ventura, CAS/N 18267512 N5098NReed Kenneth C · Hollywood, MDBuilt 1980 · S/N 18267513 N5099NRabinowitz Jeffrey Evan · Akron, OHBuilt 1980 · S/N 18267514 N5101NMerrill Charles Jay · Manhattan, KSBuilt 1980 · S/N 18267516 N5108NBerry Lisa A · Yuba City, CAS/N 18267520 N5112NRcr Aviation LLC · Cave Creek, AZBuilt 1980 · S/N 18267524 N5115NFernandez Arriaga Emilio · Miami, FLBuilt 1980 · S/N 18267526 N5122NMeyer Ricky · New Liberty, IAS/N 18267530 N5124NSolomon Dennis R · Odessa, FLS/N 18267531 N5125NNorris Marvin D · Georgetown, TXBuilt 1980 · S/N 18267532

Back to Cessna 182Q