Skip to content

Reynolds Darryl G

Registered aircraft · 42

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 = 'REYNOLDS DARRYL G' OR list_contains(g.other_registrant_names, 'REYNOLDS DARRYL G') 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 = 'REYNOLDS DARRYL G' OR list_contains(g.other_registrant_names, 'REYNOLDS DARRYL G')
  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 = 'REYNOLDS DARRYL G' OR list_contains(g.other_registrant_names, 'REYNOLDS DARRYL G')
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.

N1044QBell UH-1H · S/N 66-17100Wills Point, TX N1045CBell OH-58 · S/N 71-20527Built 1972 · Wills Point, TX N1353UCessna 172M · S/N 17267024Built 1976 · Wills Point, TX N16929Bell 206B · S/N 2314Built 1978 · Wills Point, TX N22730Hughes 269B · S/N 790436Built 1969 · Wills Point, TX N248RACessna 172S · S/N 172S8562Built 2000 · Wills Point, TX N250RACessna 172M · S/N 17266043First renewal noticeBuilt 1975 · Wills Point, TX N251RACessna 172M · S/N 17266249First renewal noticeBuilt 1975 · Wills Point, TX N252RACessna 172N · S/N 17269911Built 1977 · Wills Point, TX N253RACessna 172P · S/N 17274790Built 1981 · Wills Point, TX N254RACessna 172M · S/N 17265910Built 1975 · Wills Point, TX N257RACessna 172M · S/N 17266240First renewal noticeBuilt 1975 · Wills Point, TX N258RACessna 172N · S/N 17270533Built 1978 · Wills Point, TX N259RACessna 172R · S/N 17280444Built 1998 · Wills Point, TX N267RACessna 172M · S/N 17261919Wills Point, TX N269AHughes 269A · S/N 1050403Built 1965 · Wills Point, TX N360EPKennelly John P LANCAIR 320/360 · S/N 850-320-692Wills Point, TX N369DRHughes 369A (OH-6A) · S/N 67-16647Built 1967 · Wills Point, TX N4425JPiper PA-28-140 · S/N 28-22825Built 1967 · Wills Point, TX N5000THughes TH-55A · S/N 64-18050Wills Point, TX N5001FHughes 269A · S/N 95-0385Built 1965 · Wills Point, TX N51741Bell OH-58A · S/N 70-15438Built 1970 · Wills Point, TX N533SDSchweizer TH55A/269A · S/N 680884Built 1968 · Wills Point, TX N582TXBell OH-58A · S/N 71-20690First renewal noticeWills Point, TX N585SDBell OH-58C · S/N 70-15585Built 1970 · Wills Point, TX N6248Hughes OH-6A · S/N 67-16248Wills Point, TX N637RAGarlick Helicopters OH-58A · S/N 7015637Built 1970 · Wills Point, TX N65168Bell OH-58A · S/N 70-15453Wills Point, TX N6846HPiper J3C-65 · S/N 20067Built 1946 · Wills Point, TX N705RMSchweizer 269C · S/N S1504Wills Point, TX N72188Bell OH-58A · S/N 68-16813Wills Point, TX N737BQCessna 172N · S/N 17269294Wills Point, TX N75591Cessna 172N · S/N 17267833Built 1977 · Wills Point, TX N8768FHughes 269A · S/N 62-0092Built 1962 · Wills Point, TX N8774FHughes 269A · S/N 0098Built 1962 · Wills Point, TX N8866FHughes 269A · S/N 0242Built 1969 · Wills Point, TX N9078FRobinson Helicopter R22 · S/N 0282Built 1982 · Wills Point, TX N911CCBell OH-58C · S/N 68-16800Built 1970 · Wills Point, TX N9385FHughes 269B · S/N 74-0112Built 1964 · Wills Point, TX N95583Hughes 269A · S/N 191068Wills Point, TX N9573VCessna 172M · S/N 17264375Built 1974 · Wills Point, TX N99RRRobinson Helicopter R44 · S/N 0653Built 1999 · Wills Point, TX

Back to Reynolds Darryl G