Skip to content

Aerofab LAKE 250

Registered aircraft · 24

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

N110WMcroberts David M · Coolin, IDS/N 131 N14049Liberty Leasing II LLC · Melbourne, FLBuilt 1987 · S/N 48 N229ALCowboy Pilots LLC · Gilbert, AZBuilt 1988 · S/N 078 N326BWOlsen David A · Marinette, WIBuilt 1990 · S/N 109 N58LBAircraft Partners LLC · Chanhassen, MNBuilt 1990 · S/N 107 N58RDDuncan Ronald A · Anchorage, AKS/N 115 N59CARegistered aircraftBuilt 1994 · S/N 129 N704BCN8550z LLC · Grand Rapids, MIBuilt 1993 · S/N 123 N747MEEvans Mark W · Camillus, NYBuilt 1993 · S/N 117 N79MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1999 · S/N 232 N84219Manhattan Management Corp · Brooklyn, NYS/N 88 N8427EJc Aviation Inc · St Simons Island, GABuilt 1989 · S/N 94 N8434EWiborg Eric J · Fort Lauderdale, FLBuilt 1989 · S/N 99 N8435HKadac LLC · Shawano, WIS/N 102 N8548ZBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 108 N8549AEbel Keith E · Shell Knob, MOBuilt 1991 · S/N 111 N85503Merrells Grade-All Inc · Saint Cloud, FLBuilt 1993 · S/N 124 N8550RCockpit Holdings Corp · Melbourne, FLS/N 121 N8550UThompson Peter S · New Hampton, NHBuilt 1991 · S/N 122 N8551DCordingley Robert L II · Lafayette, COS/N 125 N8553YThompson Sheri Linn · Larkspur, COS/N 234 N916KWRegistration Pending · Lacon, ILRegistration pendingS/N 89 N9224DAlleman Mark J Inc · Wilmington, DES/N 31 N97TFTerell Enterprises LLC · Deland, FLBuilt 1993 · S/N 119

Back to Aerofab LAKE 250