Skip to content

Christiansen Aviation LLC

Registered aircraft · 321

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 = 'CHRISTIANSEN AVIATION LLC' OR list_contains(g.other_registrant_names, 'CHRISTIANSEN 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 = 'CHRISTIANSEN AVIATION LLC' OR list_contains(g.other_registrant_names, 'CHRISTIANSEN 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 = 'CHRISTIANSEN AVIATION LLC' OR list_contains(g.other_registrant_names, 'CHRISTIANSEN 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.

N103FVCessna 172R · S/N 17280553Built 1998 · Wilmington, DE N1047MPiper PA-28-161 · S/N 2842286Built 2007 · Wilmington, DE N1053XCessna 172S · S/N 172S9809Built 2005 · Wilmington, DE N106RACessna 172S · S/N 172S8241Built 1999 · Wilmington, DE N113SVCessna 172S · S/N 172S9512Built 2003 · Wilmington, DE N118SVCessna 172S · S/N 172S10102Built 2005 · Wilmington, DE N1210KTextron 172S · S/N 172S13048Built 2023 · Wilmington, DE N122BCTextron 172S · S/N 172S12540Built 2020 · Wilmington, DE N124CKCessna 172S · S/N 172S9808Built 2005 · Wilmington, DE N1250KTextron 172S · S/N 172S13050Built 2023 · Wilmington, DE N1260KTextron 172S · S/N 172S13053Built 2023 · Wilmington, DE N1270KTextron 172S · S/N 172S13057Built 2023 · Wilmington, DE N1280KTextron 172S · S/N 172S13064Built 2023 · Wilmington, DE N132DWPiper PA-44-180 · S/N 4496139Built 2002 · Wilmington, DE N134BCessna 172S · S/N 172S9345Built 2003 · Wilmington, DE N137MECessna 172S · S/N 172S8420Built 2000 · Wilmington, DE N1422CTextron 172S · S/N 172S12894Built 2022 · Wilmington, DE N1433CTextron 172S · S/N 172S12895Built 2022 · Wilmington, DE N1488CTextron 172S · S/N 172S12896Built 2022 · Wilmington, DE N170RBCessna 172S · S/N 172S11130Wilmington, DE N1724UCessna 172S · S/N 172S10443Built 2007 · Wilmington, DE N176BLCessna 172S · S/N 172S11287Built 2013 · Wilmington, DE N2046KTextron 172S · S/N 172S12092Built 2017 · Wilmington, DE N208CAPiper PA-44-180 · S/N 4496161Built 2002 · Wilmington, DE N208CPTextron 172S · S/N 172S12502Built 2020 · Wilmington, DE N210FLPiper PA-44-180 · S/N 4496478Built 2019 · Wilmington, DE N211TDCessna 172S · S/N 172S8524Built 2000 · Wilmington, DE N2134MCessna 172S · S/N 172S9552Built 2003 · Wilmington, DE N2138WCessna 172S · S/N 172S9561Built 2003 · Wilmington, DE N2158SCessna 172S · S/N 172S9539Built 2003 · Wilmington, DE N215LPCessna 172S · S/N 172S9215Built 2002 · Wilmington, DE N220FLPiper PA-44-180 · S/N 4496479Built 2019 · Wilmington, DE N223LPCessna 172S · S/N 172S9223Built 2002 · Wilmington, DE N227TWCessna 172S · S/N 172S9227Built 2002 · Wilmington, DE N2338WCessna 172R · S/N 17280698Built 1999 · Wilmington, DE N2369XPiper PA-44-180 · S/N 4496291Built 2011 · Wilmington, DE N236TFTextron 172S · S/N 172S12134Built 2018 · Wilmington, DE N2370FCessna 172R · S/N 17280618Built 1998 · Wilmington, DE N2373MCessna 172S · S/N 172S10592Built 2007 · Wilmington, DE N2383GCessna 172R · S/N 17280701Built 1999 · Wilmington, DE N2384LCessna 172R · S/N 17280706Built 1999 · Wilmington, DE N2387UCessna 172R · S/N 17280721Built 1999 · Wilmington, DE N2432KCessna 172R · S/N 17280870Built 2000 · Wilmington, DE N2444HCessna 172R · S/N 17280874Built 2000 · Wilmington, DE N2448BCessna 172R · S/N 17280978Built 2000 · Wilmington, DE N24532Cessna 152 · S/N 15280315Built 1977 · Wilmington, DE N245GTPiper PA-44-180 · S/N 4496489Built 2019 · Wilmington, DE N2465QCessna 172R · S/N 17281271Built 2005 · Wilmington, DE N2477FCessna 172S · S/N 172S10574Built 2007 · Wilmington, DE N276GTCessna 172S · S/N 172S9281Built 2002 · Wilmington, DE

Back to Christiansen Aviation LLC