Skip to content

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N5400APittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1957 · S/N 35600 N5406AJanke Merle D II · Simi Valley, CABuilt 1957 · S/N 35606 N5412ABlue Skies Aircraft LLC · Kalispell, MTS/N 35612 N5418ATyler James · Oklahoma City, OKBuilt 1957 · S/N 35618 N541DWJanssen Donald D · Mesa, AZBuilt 1960 · S/N 310-0021 N5435AAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1958 · S/N 35635 N543MPayne Jon R · Danville, PABuilt 1961 · S/N 320-0030 N5443JKg&C Investment LLC · Saint Charles, ILBuilt 1975 · S/N 421B0901 N5448JInfinity Aviators LLC · Scottsdale, AZBuilt 1975 · S/N 421B0906 N544RAnderson Daniel R · Venus, TXBuilt 1960 · S/N 39210 N5459ABaginski D Dianne Marie · Salesville, OHBuilt 1958 · S/N 35659 N5461AYaeger Edwin R · Stoneville, NCBuilt 1958 · S/N 35661 N5473ABoisseau Guy M · Gulf Breeze, FLBuilt 1958 · S/N 35673 N5482AMapel Steven L · May, TXBuilt 1958 · S/N 35682 N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289 N5555QPeterson Randall · Lake Havasu City, AZBuilt 1959 · S/N 35994 N555MVDavis Elijah L · West Union, OHBuilt 1966 · S/N 310K0186 N555MYSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 421B0886 N555RFRayburn Aviation LLC · Center, TXBuilt 1974 · S/N 421B0621 N558BTKeesling Roger L · Starkville, MSBuilt 1969 · S/N 310P0220 N55DKUrbina Mario Antonio · Pacoima, CABuilt 1959 · S/N 35878 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N567Herr John Robert · Saint Petersburg, FLBuilt 1972 · S/N 310Q0459 N56VPGoulette Bryan · Fort Worth, TXBuilt 1961 · S/N 320-0036 N5701MConsulat Inc · Cheyenne, WYS/N 310P-0001 N5701XCoan Mark A · Berthoud, COBuilt 1961 · S/N 320-0001 N5709MClear Blue Western Sky LLC · Anthem, AZBuilt 1968 · S/N 310P-0009 N5711MSwager Joel P · Ione, CAS/N 310P0011 N5712MDay Star Aviation Inc · Locust Grove, GABuilt 1968 · S/N 310P0012 N5714XKulon Andrew · Wyanet, ILS/N 3200014 N5715MExpress Air LLC · Wilmington, DEBuilt 1968 · S/N 310P0015 N5716XFlanegan Charles E Jr · Jonesboro, GABuilt 1961 · S/N 320-0016 N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020 N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021 N5721XRichardson John L · Anchorage, AKS/N 320-0021 N5731MZortman Micky P · Mexico, MOS/N 310P0031 N5731XLife Is Flying Inc · Deerfield Beach, FLBuilt 1961 · S/N 320-0031 N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041 N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046 N5746X300 Series Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 320-0046 N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788 N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062 N5768MHeal Your Heart LLC · Redding, CABuilt 1968 · S/N 310P0068 N5769XHagemeier Justin · Memphis, TNBuilt 1961 · S/N 320-0069 N5779XDirigo Aerospace Solutions LLC · Sumner, MES/N 320-0079 N577SWAir Plains Services Corp · Wellington, KSS/N 421-0023 N5780XWilton William H · Kailua Kona, HIBuilt 1961 · S/N 320-0080 N5781MRudnik Andrew S · Ann Arbor, MIBuilt 1969 · S/N 310P0081 N5782MGingell Robert A · Sunnyvale, CABuilt 1969 · S/N 310P0082 N5783MBig Turbine Engines LLC · Wilmington, DEBuilt 1969 · S/N 310P0083

Back to AD 72-14-08 R1