Skip to content

Registered aircraft · 10,639

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:99-01-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1') 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:99-01-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
  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:99-01-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-01-05-R1')
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.

N3479ZPhegley James R · Carlisle, INBuilt 1960 · S/N 18-7308 N3480MMegli Mike O · Dillingham, AKBuilt 1947 · S/N 12-2326 N3481MFabry Sean R · Anchorage, AKBuilt 1947 · S/N 12-2327 N3482AJerzyk James D · Bradenton, FLBuilt 1953 · S/N 22-1748 N3483MHopwood Andrew R · Elbert, COBuilt 1947 · S/N 12-2339 N3483ZRiggin Flight Service Inc · Madison, SDBuilt 1960 · S/N 18-7315 N3484MNiner One Aviation LLC · Hillsboro, ORBuilt 1947 · S/N 12-2080 N3484ZFortun Tyler T · Dassel, MNS/N 18-7316 N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317 N3487AOutka Wade R · Aberdeen, SDBuilt 1953 · S/N 22-1759 N3487MSchroeder Kenneth M Jr · Pinehurst, NCBuilt 1955 · S/N 12-2331 N3488ADanoff Michele A · Edgewater, MDBuilt 1952 · S/N 22-1760 N3488ZBastian Richard L · Burns, WYBuilt 1960 · S/N 18-7325 N3489AZgurich Joseph S · Irwin, PABuilt 1953 · S/N 22-1761 N3490AFaibisoff Isaac J · Caseyville, ILBuilt 1953 · S/N 22-1762 N3491AKendrick Jack O · Weatherford, TXBuilt 1953 · S/N 22-1763 N3491ZKratzenberg Robert J · Woodgate, NYBuilt 1960 · S/N 18-7331 N3492ATautz Herb · Mount Carroll, ILBuilt 1953 · S/N 22-1764 N3492MSchumacher Peter M · Buffalo, WYBuilt 1947 · S/N 12-2336 N3492ZMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1960 · S/N 18-7332 N3493MChristian Peter A · Eagle River, AKS/N 12-2337 N3493ZPrescott Scot A · Alburgh, VTS/N 18-7333 N3495ZDillon Edward L · Anchorage, AKBuilt 1960 · S/N 18-7336 N3496MBell Russell P · Auburn, NYBuilt 1947 · S/N 12-2081 N3497MGebhart Travis D · Meadow, SDBuilt 1947 · S/N 12-2355 N3498AKell Matthew D · Kodiak, AKS/N 22-1770 N3498MSeavoy Roger J · Mc Grath, AKBuilt 1947 · S/N 12-2087 N3499ZRedmond Perry · Fairfield, NDBuilt 1960 · S/N 18-7345 N34FGState Of Alaska · Fairbanks, AKBuilt 1978 · S/N 18-7809041 N34SFStults Curt M · Oklahoma City, OKBuilt 1959 · S/N 18-7141 N35001Mccall John Lane · Arlington, TXBuilt 1940 · S/N 4-1372 N35005Groskurth Walter I · Mankato, MNBuilt 1940 · S/N 4-1382 N3500AHoller Leo F · Wasilla, AKBuilt 1953 · S/N 22-1772 N3500ZKuyk William P Sr · Holly, MIBuilt 1960 · S/N 22-7395 N3501ASargent Amanda L · Fort Lauderdale, FLS/N 22-1773 N3501PSjoberg Leonard C · Okemah, OKBuilt 1955 · S/N 22-3251 N35020Spears Dennis R Jr · Modesto, CABuilt 1941 · S/N 5-528 N35025Bennett Jacob W · Carrollton, MSBuilt 1941 · S/N 5535 N35029Wallis Bruce W · Kingwood, TXBuilt 1941 · S/N 5539 N35035Registration Pending · Oak Grove, MNRegistration pendingBuilt 1941 · S/N 5-545 N35037Toman Michael · Painesville, OHBuilt 1941 · S/N 5-547 N3503ZMcmath Don · Collinsville, OKBuilt 1960 · S/N 22-7398 N35042Cayce Dick L Jr · Longview, TXS/N 5-554 N3504ZHeadrick John E · Eolia, MOS/N 22-7399 N35052Montei Nicholas · Caro, MIBuilt 1940 · S/N 6059 N35055Lyons James P · Fort Ogden, FLBuilt 1940 · S/N 6060 N35057Westrum Sean R · Norwalk, IABuilt 1940 · S/N 6063 N3505MMountain Green Aviation LLC · Morgan, UTBuilt 1947 · S/N 12-2353 N35067Lassiter Brent · Newport, ARS/N 6075 N3506ARjr Airdrome Inc · Dover, DEBuilt 1953 · S/N 22-1778

Back to AD 99-01-05 R1