Registered aircraft · 40,395

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N272KMHickman Michael G · Longmont, COBuilt 1997 · S/N 5003 N272KSOlson Richard · Eau Claire, WIBuilt 1967 · S/N 28-23936 N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N272ZMarson Richard W · Eagle River, AKBuilt 1998 · S/N 1050 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032 N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042 N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131 N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CC N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94 N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284 N27446Evans William Henry Jr · Gardendale, TXBuilt 1939 · S/N 2088 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346 N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78 N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053 N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104 N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143 N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054 N2747YJennflight Inc · Chagrin Falls, OHS/N TD-96 N2748GNoe Aviation LLC · Vinton, IAS/N 152 N2748PHess Gary A · Petoskey, MIBuilt 1955 · S/N 22-3055 N2748WZweifel Jonathan R · Chandler, AZBuilt 1966 · S/N 3347 N2749EB2fh Ltd · Allentown, NJBuilt 1978 · S/N 17271314 N2749MBeebe Richard W II · Hamden, CTBuilt 2001 · S/N 5057 N2749YBaker Paul D · Grand Prairie, TXBuilt 1958 · S/N TD-105 N274CTGoodwin Roger I · Palm Coast, FLBuilt 1978 · S/N M-2008 N274DMGustafson James R · Granby, MABuilt 1999 · S/N 2045 N274ERFlying Vikings Inc · Hayward, CAFirst renewal noticeBuilt 1978 · S/N 44-7995083 N274GTSkogen Joseph S · Coeur D Alene, IDBuilt 1983 · S/N 172RG1141 N274JZAcv Group LLC · Mckinleyville, CABuilt 2001 · S/N 9921CC N274TEBas Part Sales LLC · Greeley, COS/N 28-1545 N274VWBonanza Parts Inc · Davis, CABuilt 1960 · S/N TD-398 N274WEShenton John J · New Harbor, MEBuilt 1979 · S/N 18-7909120

Back to AD 79-10-03 R2