Newark, DE
Registered aircraft · 407
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
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_state = 'DE' AND g.registrant_city = 'NEWARK' 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_state = 'DE' AND g.registrant_city = 'NEWARK' 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.
N100EVPiaggio Aero Industries P180 · S/N 3013N100FKLearjet 45 · S/N 113N10242Cessna 210L · S/N 21059704N1043SCessna 172N · S/N 172-68679N1058ZCessna LC41-550FG · S/N 411058N105FCCessna 425 · S/N 425-0094N10DYDassault FALCON 7X · S/N 121N110JYYak110 YAK110 · S/N 1N11573Cessna 150L · S/N 15075533N11719Mooney M20J · S/N 24-1325N11CREmbraer EMB-500 · S/N 50000115N11THCessna 525B · S/N 525B0056N1208POlson Perry D S-6S · S/N 0695828SN121GCYakovlev YAK-50 · S/N 842901N121HCCirrus Design SR22 · S/N 0277N121HLCessna 550 · S/N 550-0121N1227QPilatus PC-12/47E · S/N 2324N1245ACessna 414A · S/N 414A1201N125DTDassault FALCON 2000EX · S/N 136N127FJCessna 525A · S/N 525A0441N128EECessna P210N · S/N P21000133N12MEEmich Michael C AX-6 · S/N 109N134KACessna T182T · S/N T18208671N1385VCessna T303 · S/N T30300266N13EHPietsch Helmut WHITE LIGHTNING · S/N 03N13ZZBeech A36 · S/N E-464N140UCessna 560XL · S/N 560-5032N150RJDassault MYSTERE-FALCON 50 · S/N 324N153RMAmerican Eurocopter AS350B3 · S/N 7495N15675Piper PA-28-140 · S/N 28-7325134N15707Piper PA-28-235 · S/N 28-7310069N159CBBoeing IB75A · S/N 75-358N163BABeech 300 · S/N FA-18N167YDassault FALCON 900 EX · S/N 167N1687FCessna 172H · S/N 17255082N17LKGulfstream Aerospace G-1159A · S/N 431N18197Cessna 150L · S/N 15073854N182AXCessna 182T · S/N 18281072N1851BBalony Kubicek Spol Sro BB37Z · S/N 1852N18KABeech 200 · S/N BB-360N191TPHawker Beechcraft 400A · S/N RK-574N1990JTextron B200GT · S/N BY-336N1TACessna 172L · S/N 17260453N2000LDassault FALCON 2000 · S/N 109N200RGHawker Beechcraft HAWKER 750 · S/N HB-31N201KTMooney M20J · S/N 24-0467N2033British Aerospace BAE 125 SERIES 800A · S/N 258093N203AGCSP Leasing CAVALON · S/N V00225N205FUBell UH-1H · S/N 70-16416N212RRCirrus Design SR22T · S/N 2357
Back to Newark, DE