Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N736NEMahoney Daniel P III · Locust Grove, VABuilt 1977 · S/N R1722651 N736NFFhr Inc · Honolulu, HIBuilt 1977 · S/N R1722652 N736NHCi Aviation LLC · Broadview Heights, OHBuilt 1977 · S/N R1722654 N736NKMaine Air Physician Services LLC · Machias, MEBuilt 1977 · S/N R1722656 N736NNM2 Aviation LLC · White Lake, MIBuilt 1977 · S/N R1722659 N736NPMbn Leasing LLC · Dover, DEBuilt 1977 · S/N R1722660 N736NQAs In The Key Aviation LLC · Marathon, FLBuilt 1977 · S/N R1722661 N736NWG Force LLC · Las Vegas, NVBuilt 1977 · S/N R1722667 N736NZColey Steven J · Baker City, ORBuilt 1977 · S/N R1722670 N736PBWoods Joyce M Trustee · Albuquerque, NMBuilt 1977 · S/N R1722671 N736PCMoore Glen O · Carson City, NVBuilt 1977 · S/N R1722672 N736PDMiner'S Outdoor Adventures LLC · Hermantown, MNBuilt 1977 · S/N R1722673 N736PEBohannon Ronald D · Newburgh, INBuilt 1977 · S/N R1722674 N736PHReynolds Thomas J · Dillon, MTBuilt 1977 · S/N R1722677 N736PKA&R In The Clouds LLC · Myrtle Beach, SCBuilt 1977 · S/N R1722679 N736PLSims Charles R Jr · Tuscumbia, ALS/N R1722680 N736PMBennett James P · Milford, DEBuilt 1977 · S/N R1722681 N736PWTheno Steven M · Coupeville, WABuilt 1977 · S/N R1722690 N736QFWilliams Mitchell L · Chickasha, OKBuilt 1977 · S/N R1722699 N736QGG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N R1722700 N736QNSkjonsberg Robert A · New Effington, SDS/N R1722706 N736QSWerme Eric Brian · King George, VABuilt 1977 · S/N R1722710 N736QYWanken Troy F · Shelby, MTFirst renewal noticeBuilt 1977 · S/N R1722716 N736RCAtwood William E · Millersville, MDBuilt 1977 · S/N R1722720 N736RFBiz Flyers LLC · Great Falls, MTBuilt 1977 · S/N R1722723 N736RHJabavu Aviation LLC · Cedar Hill, TXBuilt 1977 · S/N R1722725 N736RKRegistered aircraftBuilt 1977 · S/N R1722727 N736RPExtter Aviation LLC · Parker, COS/N R1722731 N736RRWatts Glenn L · Anchorage, AKBuilt 1977 · S/N R1722733 N736RUGlaeser Robert L · Portland, ORBuilt 1977 · S/N R1722736 N736RVPerrin J R · Omaha, NEBuilt 1977 · S/N R1722737 N736RWHoward County Flying Club Inc · Grand Island, NEBuilt 1977 · S/N R1722738 N736RXTop Notch Services LLC · Glen Cove, NYBuilt 1977 · S/N R1722739 N736RZShipol Flying LLC · Sacramento, CABuilt 1977 · S/N R1722741 N736SDJcp Thrift Inc · Ocean Springs, MSS/N R1722745 N736SEJones Harry N · Kathleen, GABuilt 1977 · S/N R1722746 N736SKHawe Christopher · Homer, AKBuilt 1977 · S/N R1722751 N736SLLang Inc · Wilmington, DEBuilt 1977 · S/N R1722752 N736SPColberg Stefan · North Bend, ORBuilt 1977 · S/N R1722755 N736SXWalls Chris K · Lawrenceville, GABuilt 1977 · S/N R1722762 N736SYGosch Peter J · Littleton, COBuilt 1977 · S/N R1722763 N736TASlc LLC · Las Vegas, NVBuilt 1977 · S/N R1722765 N736TCJia Li · Chandler, AZS/N R1722767 N736TELissie Flying Service Inc · Lissie, TXBuilt 1977 · S/N R1722769 N736TP4110 Aviation LLC · Rome, GABuilt 1977 · S/N R1722778 N736TTWillard Michael E · Colorado Springs, COBuilt 1977 · S/N R1722782 N736TUMathwig Althea G · Glencoe, MNBuilt 1977 · S/N R1722783 N736TVRegistration Pending · Mocksville, NCRegistration pendingBuilt 1977 · S/N R1722784 N736TXN736 Tango Xray LLC · Paw Paw, ILBuilt 1977 · S/N R1722785 N736UASandstrom Jeff A · Anchorage, AKBuilt 1977 · S/N R1722788

Back to AD 81-13-10 R1