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.

N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N104JSSmith Timothy A · Shafter, CABuilt 1977 · S/N 18265625 N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N10948Morris Jacky D · Watonga, OKBuilt 1977 · S/N 18266102 N11182Smith Brian · Roanoke, TXBuilt 1979 · S/N 18266815 N112DSCarter Erick D · Eugene, ORBuilt 1977 · S/N 18265826 N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300 N116SUBoolean Flight Sciences LLC · Mercer Island, WAS/N 18266668 N117PHR & R Leasing LLC · Fargo, NDBuilt 1977 · S/N 18265492 N117TTMustang LLC · Wilsonville, ORBuilt 1978 · S/N 18266432 N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086 N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498 N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094 N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746 N125PBEvergreen Financial Investments LLC · Wayzata, MNBuilt 1977 · S/N 18265348 N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774 N12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528 N136STScull Timber Co Inc · Tenaha, TXBuilt 1978 · S/N 18266476 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N141WBElevated Dreams Aviation LLC · Huntington, NYBuilt 1976 · S/N 18265249 N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699 N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435 N148GMorrill William I · Kerrville, TXBuilt 1979 · S/N 18267097 N148TXRegistration Pending · Austin, TXRegistration pendingBuilt 1979 · S/N 18267500 N153PPBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 18266340 N155AZCoconino County Sheriffs Office · Flagstaff, AZBuilt 1980 · S/N 18267636 N15AZHopkins Todd · Russellville, INBuilt 1979 · S/N 18267118 N15BPTidmore Argie D · Pottsville, PABuilt 1979 · S/N 18266877 N162BJAircraft Ownership Solutions LLC · Kokomo, INBuilt 1978 · S/N 18266440 N162JSPeeler Jason Byron · Floresville, TXBuilt 1980 · S/N 18267510 N1658AApplied Trails Research LLC · Staunton, VABuilt 1978 · S/N 18266315 N165AMitchell Flying Club Inc · Lees Summit, MOBuilt 1979 · S/N 18267062 N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456 N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267 N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507 N180TLDoebler H Andrew · Mebane, NCBuilt 1978 · S/N 18266584 N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532 N181EWoodhead Matthew E Trustee · Reno, NVBuilt 1979 · S/N 18267304 N1824GHarkness Michael D · San Luis Obispo, CABuilt 1977 · S/N 18265819 N182ACNickles Sid · Lodi, CABuilt 1979 · S/N 18267482 N182AKBluebird Pacific Aviation LLC · Oakland, CABuilt 1979 · S/N 18267486 N182APN7476s LLC · Venice, FLBuilt 1976 · S/N 18265198 N182AQTerlingua Flying LLC · Mansfield, TXBuilt 1979 · S/N 18266917

Back to Cessna 182Q