Skip to content

Registered aircraft · 4,469

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-20-04-R2')
ORDER BY 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.

N181PJPeake Herschel S · Dallas, TXBuilt 1976 · S/N D-9876 N181RMHennessee Timothy · New Braunfels, TXBuilt 1961 · S/N D-6666 N1821DBowman Kent · Rexburg, IDS/N D-3090 N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377 N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424 N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877 N18276Stack Ed · Prospect Heights, ILS/N D-10031 N18287Three Wings Aviation LLC · Kalispell, MTBuilt 1977 · S/N D-10032 N18294Bundy Holdings LLC · Walnut Grove, MOBuilt 1977 · S/N D-10034 N182QWhitt Carson M · Deland, FLBuilt 1964 · S/N D-7646 N18304Bean David Jay · Miami, TXBuilt 1977 · S/N D-10037 N18307Wings Management LLC · Springville, UTBuilt 1977 · S/N D-10038 N1830WSoyars Tom · San Marcos, TXBuilt 1973 · S/N D-9428 N18315Gregory G William Jr · York, SCBuilt 1977 · S/N D-10039 N18318Registration Pending · Fosters, ALRegistration pendingBuilt 1977 · S/N D-10041 N18329Coggin Marilyn · Longview, TXBuilt 1977 · S/N D-10044 N18331Fred Garrison Oil Co · Plainview, TXBuilt 1977 · S/N D-10042 N18337Urban James G · Panama City, FLBuilt 1977 · S/N D-10047 N1834DBuchanan Jason A · Nampa, IDS/N D-3101 N1834WTri-Aero Of Grand Rapids · Ada, MIBuilt 1973 · S/N D-9429 N1835DAirspeed Jet Services LLC · Kirkland, WAS/N D-3097 N18368Olaf LLC · Bellbrook, OHBuilt 1977 · S/N D-10049 N18369Barmakian Bruce · San Bernardino, CABuilt 1977 · S/N D-10050 N1837DSpivey Clay · Valdosta, GABuilt 1952 · S/N D-3099 N1837LHornby Mark H · New Bern, NCBuilt 1976 · S/N D-9881 N1837ZBert Aviation LLC · Clemmons, NCBuilt 1981 · S/N D-10317 N183QDrajesk Jeffrey F · Fish Creek, WIBuilt 1965 · S/N D-7883 N183RLea Brandon Wayne Sr · Bartlett, TNBuilt 1957 · S/N D-5155 N1840DNewlin Thomas R · Montezuma, INBuilt 1952 · S/N D-3094 N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431 N1842DCoughlin Patrick J · Nashua, NHBuilt 1952 · S/N D-3098 N1843DSales Joe H · Seminole, TXBuilt 1952 · S/N D-3111 N1844DSalimi Patrick · Shingle Springs, CABuilt 1952 · S/N D-3141 N1844LRao Enterprises LLC · Brighton, MIBuilt 1976 · S/N D-9880 N18470Entwistle Charles W · Leicester, MABuilt 1977 · S/N D-10065 N1849DBerka George · Wilmington, DEBuilt 1952 · S/N D-3100 N184QSchmuker David Joseph · Grand Rapids, MIBuilt 1959 · S/N D-5954 N1850DLeupp John R · Taylors, SCBuilt 1952 · S/N D-3116 N1852DEbers Harold Dewayne · Hennessey, OKBuilt 1952 · S/N D-3114 N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477 N1855D55 Delta LLC · Jacksonville, FLBuilt 1952 · S/N D-3130 N1856DByrd Aviation LLC · Marshfield, MOS/N D-3112 N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889 N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503 N185THsr Creative LLC · Indian Trail, NCS/N D-9672 N1860DRay Charlie B · Prosser, WABuilt 1951 · S/N D-3125 N1860WWhittaker Gary · Southport, NCBuilt 1973 · S/N D-9500 N1866DFarris Russell L · Fort Mill, SCBuilt 1952 · S/N D-3136 N186BBowen John J · Granbury, TXBuilt 1956 · S/N D-4484 N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644

Back to AD 94-20-04 R2