Lift Aircraft LLC
Registered aircraft · 111
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 = 'LIFT AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'LIFT AIRCRAFT 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 = 'LIFT AIRCRAFT LLC' OR list_contains(g.other_registrant_names, 'LIFT AIRCRAFT 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.
N179LDiamond Aircraft Ind DA 40 NG · S/N 40.NC094N225NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC019N242EAPipistrel D O O ALPHA TRAINER · S/N 1163 AT 912 LSAN243EAPipistrel D O O ALPHA TRAINER · S/N 1164 AT 912 LSAN247EAPipistrel D O O ALPHA TRAINER · S/N 1166 AT 912 LSAN252EAPipistrel D O O ALPHA TRAINER · S/N 1167 AT 912 LSAN253EAPipistrel D O O ALPHA TRAINER · S/N 1186 AT 912 LSAN254EAPipistrel D O O ALPHA TRAINER · S/N 1187 AT 912 LSAN257EAPipistrel D O O ALPHA TRAINER · S/N 1188 AT 912 LSAN258EAPipistrel D O O ALPHA TRAINER · S/N 1189 AT 912 LSAN316LDiamond Aircraft Ind DA 40 NG · S/N 40.NC281N351LDiamond Aircraft Ind DA 40 NG · S/N 40.NC051N357EAPipistrel D O O ALPHA TRAINER · S/N 1200 AT 912 LSAN358EAPipistrel D O O ALPHA TRAINER · S/N 1201 AT 912 LSAN364EAPipistrel D O O ALPHA TRAINER · S/N 1202 AT 912 LSAN366EAPipistrel D O O ALPHA TRAINER · S/N 1203 AT 912 LSAN366LDiamond Aircraft Ind DA 40 NG · S/N 40.NC073N367LDiamond Aircraft Ind DA 40 NG · S/N 40.NC075N368LDiamond Aircraft Ind DA 40 NG · S/N 40.NC079N386LDiamond Aircraft Ind DA 42 NG · S/N 42.N526N387LDiamond Aircraft Ind DA 42 NG · S/N 42.N551N389LDiamond Aircraft Ind DA 42 NG · S/N 42.N555N390LDiamond Aircraft Ind DA 42 NG · S/N 42.N557N391LDiamond Aircraft Ind DA 42 NG · S/N 42.N561N438LDiamond Aircraft Ind DA 40 NG · S/N 40.NC095N443LDiamond Aircraft Ind DA 40 NG · S/N 40.NC211N445LDiamond Aircraft Ind DA 40 NG · S/N 40.NC214N446LDiamond Aircraft Ind DA 40 NG · S/N 40.NC223N452LDiamond Aircraft Ind DA 40 NG · S/N 40.NC053N458LDiamond Aircraft Ind DA 42 NG · S/N 42.N479N462LDiamond Aircraft Ind DA20-C1 · S/N C0727N465LDiamond Aircraft Ind DA20-C1 · S/N C0728N470LPPipistrel D O O ALPHA TRAINER · S/N 1147 AT 912 LSAN472LPPipistrel D O O ALPHA TRAINER · S/N 1146 AT 912 LSAN475LPPipistrel D O O ALPHA TRAINER · S/N 1145 AT 912 LSAN476LPPipistrel D O O ALPHA TRAINER · S/N 1143 AT 912 LSAN478LPPipistrel D O O ALPHA TRAINER · S/N 1148 AT 912 LSAN479LPPipistrel D O O ALPHA TRAINER · S/N 1149 AT 912 LSAN480LPPipistrel D O O ALPHA TRAINER · S/N 1150 AT 912 LSAN481LPPipistrel D O O ALPHA TRAINER · S/N 1151 AT 912 LSAN483LPPipistrel D O O ALPHA TRAINER · S/N 1152 AT 912 LSAN484LPPipistrel D O O ALPHA TRAINER · S/N 1153 AT 912 LSAN485LPPipistrel D O O ALPHA TRAINER · S/N 1154 AT 912 LSAN486LPPipistrel D O O ALPHA TRAINER · S/N 1155 AT 912 LSAN487LPPipistrel D O O ALPHA TRAINER · S/N 1156 AT 912 LSAN490LPPipistrel D O O ALPHA TRAINER · S/N 1157 AT 912 LSAN491LPPipistrel D O O ALPHA TRAINER · S/N 1158 AT 912 LSAN492LPPipistrel D O O ALPHA TRAINER · S/N 1159 AT 912 LSAN515NGDiamond Aircraft Ind DA 40 NG · S/N 40.NC022N532LDiamond Aircraft Ind DA 40 NG · S/N 40.NC274
Back to Lift Aircraft LLC