Registered aircraft · 31

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 = 'IAL CORP' OR list_contains(g.other_registrant_names, 'IAL CORP') 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 = 'IAL CORP' OR list_contains(g.other_registrant_names, 'IAL CORP')
  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 = 'IAL CORP' OR list_contains(g.other_registrant_names, 'IAL CORP')
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.

N113KRPiper PA-28-151 · S/N 28-7415211Built 1974 · Lewes, DE N121MJCessna 550 · S/N 550-0489Built 1984 · Lewes, DE N158NCBeech 58 · S/N TH-444Built 1974 · Lewes, DE N161JGCanadair CL-600-2B16 · S/N 5028Built 1988 · Lewes, DE N170TBPiper PA-34-200 · S/N 34-7350190Built 1973 · Lewes, DE N174DRCessna 550 · S/N 550-0074Built 1979 · Lewes, DE N179CJAvions Marcel Dassault MYSTERE-FALCON 20-C5 · S/N 176Lewes, DE N228NCPiper PA-28R-200 · S/N 28R-35652Built 1969 · Lewes, DE N234NCPiper PA-34-200 · S/N 34-7350146Built 1973 · Lewes, DE N236NCPiper PA-28-236 · S/N 28-8311022Lewes, DE N28KUPiper PA-28-181 · S/N 2881142Lewes, DE N31183Carlson Anders James CUBBY · S/N AC-01Built 2007 · Lewes, DE N31397Piper PA-32RT-300 · S/N 32R-7885093Lewes, DE N32TPBeech 200 · S/N BB-456Built 1979 · Lewes, DE N369BCessna 750 · S/N 750-0030Built 1997 · Lewes, DE N372GGCessna 172P · S/N 17274926Built 1981 · Lewes, DE N391RCShort Bros SD3-60 · S/N SH3665Lewes, DE N396SKCessna 172P · S/N 17274143Lewes, DE N54HPRaytheon 400A · S/N RK-160Lewes, DE N588SDRaytheon C90A · S/N LJ-1663Lewes, DE N65773Cessna 172P · S/N 17275876Built 1982 · Lewes, DE N6665WBeech 58P · S/N TJ-227Built 1979 · Lewes, DE N71NEGulfstream Aerospace G-IV · S/N 1174Built 1991 · Lewes, DE N787TKPiper PA-28-181 · S/N 2881144Lewes, DE N804STCessna 501 · S/N 501-0146Built 1980 · Lewes, DE N858NCBeech 58 · S/N TH-813Built 1977 · Lewes, DE N907WRBombardier CL-600-2B16 · S/N 5571Built 2003 · Lewes, DE N9237YPiper PA 31P 350 · S/N 31P-8414022Lewes, DE N9272YPiper PA 31P 350 · S/N 31P-8414039Built 1984 · Lewes, DE N972NCCessna 172L · S/N 17259818Built 1971 · Lewes, DE N9837LCessna 172P · S/N 17276629Built 1986 · Wilmington, DE

Back to Ial Corp