Earlier aircraft under this name · 20

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'LAPEER AIRPORT INC' OR list_contains(d.other_registrant_names, 'LAPEER AIRPORT INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'LAPEER AIRPORT INC' OR list_contains(d.other_registrant_names, 'LAPEER AIRPORT INC')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'LAPEER AIRPORT INC' OR list_contains(d.other_registrant_names, 'LAPEER AIRPORT INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N36972Aeronca 65-TAF · S/N 4212Cancelled Jan 5, 1949 · Lapeer, MI N52305Aeronca L-3C · S/N 6732Cancelled Nov 18, 1948 · Built 1945 · Lapeer, MI N52452Aeronca L-3 · S/N 058B1882Cancelled Nov 18, 1948 · Built 1945 · Lapeer, MI N51405Taylorcraft DCO-65 · S/N 5560Cancelled Nov 15, 1948 · Lapeer, MI N51410Taylorcraft BL-65 · S/N 3062Cancelled Nov 10, 1948 · Lapeer, MI N29348Waco UPF-7 · S/N 5375Cancelled Nov 8, 1948 N49651Boeing PT-17 · S/N 75-2463Cancelled Nov 4, 1948 · Lapeer, MI N47200Taylorcraft L-2A · S/N L-5120Cancelled Nov 1, 1948 N47201Taylorcraft L-2A · S/N 6-5156Cancelled Nov 1, 1948 N47429Aeronca 0-58B · S/N 058B-2942Cancelled Nov 1, 1948 N47430Aeronca 0-58B · S/N 058B-9363Cancelled Nov 1, 1948 N47281Taylorcraft DCO-65 · S/N L-5087Cancelled Oct 26, 1948 N47338Taylorcraft DCO-65 · S/N 5123Cancelled Oct 26, 1948 N26495Berk Glen W A · S/N 3Cancelled Sep 28, 1948 · Lapeer, MI N38844Piper J3L-65 · S/N 7331Cancelled Sep 16, 1948 · Built 1941 · Lapeer, MI N33794Aeronca 65-TL · S/N 9531Cancelled Aug 20, 1948 · Lapeer, MI N33834Aeronca 65-TL · S/N 9681Cancelled Aug 20, 1948 · Lapeer, MI N34612Stinson 10A · S/N 8012Cancelled Aug 17, 1948 · Lapeer, MI N47363Taylorcraft DCO-65 · S/N 0-4235Cancelled Nov 29, 1945 N34300Meyers OTW · S/N 44Cancelled Nov 19, 1945 · Lapeer, MI

Back to Lapeer Airport Inc