Registered aircraft · 18

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'NORTHERN AVIATION LLC' OR list_contains(g.other_registrant_names, 'NORTHERN AVIATION LLC') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'NORTHERN AVIATION LLC' OR list_contains(g.other_registrant_names, 'NORTHERN AVIATION LLC')
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'NORTHERN AVIATION LLC' OR list_contains(g.other_registrant_names, 'NORTHERN AVIATION LLC')
ORDER BY g.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.

N157MAshura Michael J FLYBABY 1A · S/N 70-5293Built 1994 · Palmer, AK N181DWPiper PA-32R-300 · S/N 32R-7680440Palmer, AK N185KCessna A185E · S/N 18501890Built 1971 · Palmer, AK N2348DCessna 170B · S/N 20500Built 1955 · Palmer, AK N2JYSchweizer SGS 1-35 · S/N 56Built 1976 · Palmer, AK N312ASNorth American T-28B · S/N 138213Built 1955 · Palmer, AK N3609QPiper PA-32R-300 · S/N 32R-7780319Built 1977 · Palmer, AK N404CKBeech C-45H · S/N AF-297Built 1953 · Anchorage, AK · Co-owner with N404ck LLC N41677Bellanca 7GCBC · S/N 585-73Built 1973 · Palmer, AK N5202NCessna 182Q · S/N 18267568Built 1980 · Palmer, AK N65BHBoeing E75L300 · S/N 75-6865Wauseon, OH N71ASSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B-812Palmer, AK N79PLLake LA-4-200 · S/N 640Built 1974 · Palmer, AK N8590YPiper PA-30 · S/N 30-1641Built 1968 · Palmer, AK N86BSSkyco SHA GLASAIR · S/N SN-412RBuilt 1986 · Palmer, AK N900AKSmith AEROSTAR 601P · S/N 61P-0365-115Built 1976 · Palmer, AK N98WERaytheon A36 · S/N E-3146Built 1997 · Roberts, MT N9QBEskildsen STEEN SKYBOLT · S/N BE1Built 1975 · Palmer, AK

Back to Northern Aviation LLC