Skip to content

Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N35411Cherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 17256755 N3541EClear Skies Aviation LLC · Longs, SCBuilt 1978 · S/N 17271578 N35420Edwards David S · Colbert, WABuilt 1968 · S/N 17256759 N35421Gleason Franklin R · Darlington, SCFirst renewal noticeBuilt 1968 · S/N 17256760 N35422Hamilton Pamela P · Norman Park, GABuilt 1968 · S/N 17256761 N35423Curenton Rufus B · Elmore, ALBuilt 1968 · S/N 17256762 N35425Calloway Julius W III · Indianapolis, INBuilt 1968 · S/N 17256763 N3542CRobertson Braxton Cecil · Selma, NCS/N 26585 N3542SKing Theresa Ann · Bakersfield, CABuilt 1963 · S/N 17250742 N3542UChristensen Paul · Granite Falls, WABuilt 1963 · S/N 18254942 N3542YNash Richard P · Missoula, MTBuilt 1962 · S/N 18254442 N3543Jaws Air LLC · Gainesville, FLBuilt 1962 · S/N 15059488 N35434Chalk 2 Inc · Apple Valley, CABuilt 1968 · S/N 17256768 N3543CMock Lurita M · Anderson, INBuilt 1954 · S/N 26586 N3543FKorngold Brandon L · Aliso Viejo, CABuilt 1966 · S/N 18257543 N3543JRegistration Pending · Bridgeport, PARegistration pending, pending cancellationBuilt 1965 · S/N 15061243 N3543LPeaster David · Brunswick, GABuilt 1965 · S/N 15062343 N35441Boe Shay Lynn · Mesa, COBuilt 1968 · S/N 17256771 N35443Registered aircraftBuilt 1973 · S/N 21059992 N35446Adelman Hiram · Bass Harbor, MES/N 17256773 N35449Whitlow Ray T · Shelbyville, KYBuilt 1968 · S/N 17256774 N3544CAryana Arash · Livermore, CABuilt 1954 · S/N 26587 N3544FFercho Corliss Y · Glendive, MTBuilt 1966 · S/N 18257544 N3544STucker Nicholas · Sebastopol, CABuilt 1963 · S/N 17250744 N3544UKarmik Aviation LLC · Fort Edward, NYS/N 18254944 N3544YPeters Ben · Seminole, TXBuilt 1962 · S/N 18254444 N35450Cole William A · San Francisco, CABuilt 1968 · S/N 17256775 N35454Norman Robert Alan · Zanesville, OHBuilt 1968 · S/N 17256778 N35456Wing Dock LLC · Miami, OKBuilt 1968 · S/N 17256779 N3545DHudson Guy G · Chickaloon, AKS/N 27088 N3545SMaldonado Edward R · Independence, ORBuilt 1963 · S/N 17250745 N3545VSoaring Pinions LLC · Rittman, OHBuilt 1975 · S/N 15076541 N35461Registered aircraftBuilt 1968 · S/N 17256781 N35465Hunkus Kenneth F · San Angelo, TXS/N 17256783 N35467Brown Wilson J · Statesville, NCBuilt 1968 · S/N 17256785 N35469Oord Joshua · Moses Lake, WABuilt 1968 · S/N 17256786 N3546EDussinger Andrew M · Enola, PABuilt 1978 · S/N 17271582 N3546FN3546f LLC · Kitty Hawk, NCBuilt 1966 · S/N 18257546 N3546JFerguson David G · Candler, NCBuilt 1965 · S/N 15061246 N3546SJackson Harry Jason · El Centro, CAS/N 17250746 N35470Lombardi Michael J · Bloomfield Hills, MIBuilt 1968 · S/N 17256787 N35474Massey Shawn A · Satanta, KSBuilt 1968 · S/N 17256789 N35477Schmidt Edward J Sr · North Brunswick, NJBuilt 1968 · S/N 17256790 N3547SThhm LLC · Menomonie, WIBuilt 1963 · S/N 17250747 N3547UPanhandle Aviation LLC · Thatcher, AZBuilt 1963 · S/N 18254947 N3547YS & W Aviation LLC · Saint Peters, MOBuilt 1962 · S/N 18254447 N35486Metz Air LLC · Little Rock, ARS/N 17256796 N35488Collins Mason G · Gillette, WYS/N 17256797 N35495Whitfill Charles Carlton · Blum, TXBuilt 1976 · S/N 177RG1050 N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996

Back to AD 87-20-03 R2