Skip to content

Registered aircraft · 2,099

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

N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879 N31AJ1 Alpha Jadzia LLC · Fort Worth, TXBuilt 1975 · S/N 18264449 N31MRAllred Don J · Wellington, TXBuilt 1974 · S/N 18262907 N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345 N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756 N322KDI Fly High Flight Services LLC · Lovejoy, GABuilt 1973 · S/N 18262285 N322PHCafferty Associates Inc · Sarasota, FLBuilt 1972 · S/N 18261339 N324YCesscon LLC · Yalesville, CTBuilt 1976 · S/N 18264524 N327DMMullin Clint · Lambert, MTS/N 18262924 N32806Nimsic Thomas L · Carson City, NVBuilt 1976 · S/N 18264943 N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043 N32AKHummel Karl · Brooklyn, NYBuilt 1973 · S/N 18261935 N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322 N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634 N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242 N3330JDownwind Three Six LLC · Murfreesboro, TNBuilt 1974 · S/N 18263456 N333PLPilot Maker LLC · Hayward, CABuilt 1972 · S/N 18261303 N3430LDachniwsky Holdings LLC · Southlake, TXBuilt 1974 · S/N 18263459 N344KLeblanc Debrah · Zachary, LABuilt 1975 · S/N 18263709 N34JSJ & K Aviation LLC · Bristow, OKBuilt 1976 · S/N 18264675 N3500YTuff Aviation LLC · Belmont, MIS/N 18262195 N35BRSlaughter Robert H · Spring, TXBuilt 1975 · S/N 18264274 N35CFGilbert David · Othello, WABuilt 1972 · S/N 18261235 N35GVMartin Scott W · Bowie, MDBuilt 1976 · S/N 18264828 N35MQFly Planet LLC · Kalispell, MTBuilt 1973 · S/N 18262505 N360ACAlpha Charlie LLC · Post Falls, IDBuilt 1975 · S/N 18263631 N360JBSouthpark Partnership Ltd · Cullman, ALBuilt 1975 · S/N 18264476 N362PC362 Papa Charlie LLC · Spokane, WABuilt 1972 · S/N 18261242 N367TJFlorida Aerial Services Inc · Lutz, FLBuilt 1975 · S/N 18263721 N377TMQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 18261750 N37TJHodl Partners LLC · Allen, TXBuilt 1976 · S/N 18264795 N38ZZZulu Zulu Av8 Inc · Las Vegas, NVS/N 18262727 N39282Rentrop Gary R · Cross Village, MIS/N 18261877 N395STCm Golf LLC · Sacramento, CABuilt 1973 · S/N 18262665 N3DWWhite Robert D Trustee · Colorado Springs, COBuilt 1973 · S/N 18262003 N3LUKirby & Associates Texas Lp · West Hills, CAS/N 18264437 N3QZTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 18261649 N3VZHavard Mark · Groves, TXBuilt 1976 · S/N 18265132 N40007Kelleher Timothy J · Lake Placid, NYS/N 182-61875 N4007Empire Ranch Inc · Lebanon, MOFirst renewal noticeBuilt 1973 · S/N 18262208 N401SSN401ss LLC · Arvada, COBuilt 1976 · S/N 18265067 N402FUSarment David · Ann Arbor, MIBuilt 1973 · S/N 18261534 N403GMBalisky Micah · Fort Shaw, MTBuilt 1972 · S/N 18260967 N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147 N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088 N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242 N4107BMullins Esten R · El Paso, TXBuilt 1976 · S/N 18264862 N410ADCon Air LLC · Okeana, OHBuilt 1975 · S/N 18263881 N410RFFeldtman Robert W · Buckholts, TXBuilt 1974 · S/N 18263478 N417LFRussell Tommy Edward · Kingsport, TNBuilt 1976 · S/N 18264714

Back to Cessna 182P