OpenAirDocs.org
Sch Aviation Inc Trustee

Registered aircraft · 30

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
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 = 'SCH AVIATION INC TRUSTEE' OR list_contains(g.other_registrant_names, 'SCH AVIATION INC TRUSTEE')
  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.

N102CDCirrus Design SR20 · S/N 1016Built 2000 · Sporle Kings LynnN111HYCommander 114-B · S/N 14569NorfolkN119ALCirrus Design SR22 · S/N 3896Sporle Kings LynnN123UKMooney M20J · S/N 24-3167Built 1990 · NorfolkN13243Cessna 172M · S/N 17262604Built 1973 · Sporle Kings LynnN1349ZReims CESSNA F152 · S/N 1879Built 1981 · NorfolkN142SDCessna 414 · S/N 414-0635Built 1975 · Kings LynnN150ZZCirrus Design SR22 · S/N 2609Built 2007 · Sporle Kings LynnN172PLReims CESSNA F172E · S/N 0055Built 1964 · Sporle Kings LynnN174YMCirrus Design SR22 · S/N 3644Built 2010 · Sporle Kings LynnN20WLPiper PA-31T · S/N 31T-7720011Built 1976 · Sporle Kings LynnN216GCPiper PA-28R-200 · S/N 28R-7135151Built 1971 · Sporle Kings LynnN256DDMooney M20J · S/N 24-1080Sporle Kings LynnN2654EPiper PA-39 · S/N 39-93Built 1971 · Sporle Kings LynnN269PCCessna 340A · S/N 340A0785Built 1979 · SporleN27LLSmith AEROSTAR 601P · S/N 61P-0348-105Built 1976 · NorfolkN323FLPiper PA-46-310P · S/N 468508096Built 1985 · Sporle Kings LynnN388APCirrus Design SR22 · S/N 2440Built 2007 · Sporle Kings LynnN425NCCessna 425 · S/N 425-0219Built 1984 · NorfolkN510KTEmbraer EMB-120ER · S/N 120.117SporleN584BCirrus Design SR22 · S/N 2330Built 2007 · NorfolkN59YMInnovaviation S R L FX1 · S/N 004Built 2021 · Sporle Kings LynnN647DKBeech V35 · S/N D-8583Built 1967 · Sporle Kings LynnN666MTReims CESSNA F172M · S/N 0985Built 1973 · NorfolkN707MKBell Helicopter Textron 206B · S/N 4633Built 2007 · NorfolkN715SRCirrus Design SR22 · S/N 2284Built 2006 · NorfolkN721VCCirrus Design SR22 · S/N 0361Built 2002 · SporleN80NSCirrus Design SR22 · S/N 2839Built 2007 · Sporle Kings LynnN811DMCirrus Design SR22T · S/N 1663Built 2018 · Sporle Kings LynnN939PAPiper PA46R-350T · S/N 4692093Built 2008 · Norfolk
Back to Sch Aviation Inc Trustee