Registered aircraft · 1,074

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-21-01-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:79-21-01-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:79-21-01-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:79-21-01-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:79-21-01-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:79-21-01-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.

N690PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0613E N690WAWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 1170237D N691PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0611E N692PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0612E N694ATSzucs Attlia · Port Orange, FLBuilt 1988 · S/N 0310E N695MCTom Cline Helicopter LLC · Lake Ozark, MOBuilt 1968 · S/N 300 N69875Gateway Youth Aeronautical Foundation · Maryland Heights, MOBuilt 2001 · S/N 5282 N69DVTripwire South LLC · Gettysburg, PABuilt 1981 · S/N 410950D N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025 N69GECbft LLC · Mobile, ALBuilt 1990 · S/N 0394E N69TPAirtime Marketing LLC · Middletown, DEBuilt 1994 · S/N LN063 N6BUAgricultural Air Services LLC · Jupiter, FLBuilt 1988 · S/N 4034 N6MQR Consulting & Sales Inc · Carson City, NVS/N 7321 N6QDSierra Golf Rotorcraft LLC · Wilmington, DEBuilt 1992 · S/N 4247 N6ULHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52015 N6YJetran LLC · Horseshoe Bay, TXBuilt 1989 · S/N 001 N700FKBhh Leasing #4 LLC · Pensacola, FLBuilt 1989 · S/N 2201 N701HAHelo N701ha LLC · Richmond, VABuilt 2001 · S/N 4554 N701KPKp Properties LLC · Auburn, WAS/N 1280417D N702BABlue Air Training Corp · Las Vegas, NVBuilt 1986 · S/N 018 N702CG702cg LLC · Muskogee, OKBuilt 1960 · S/N 6030 N702SH702sh LLC · Kalispell, MTBuilt 1978 · S/N 1280404D N70512Bank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N LN092 N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836 N705KPOceans Alaska LLC · Dover, DEBuilt 1996 · S/N 0530E N705MPSmith Mark K DBA · Hubertus, WIBuilt 1990 · S/N 0405E N7062XPatriot Aviation Inc · Greenville, DES/N S-793 N7079KDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 610988D N707HJIndustrial Helicopters LLC · Lafayette, LABuilt 1980 · S/N 3173 N707MDEfw Inc · Fort Worth, TXBuilt 1984 · S/N 5306 N707SJCtrg Aviation Holdings LLC · Lakeway, TXBuilt 1981 · S/N 3561 N709ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5114 N710ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5234 N711HLMann Laurence F · San Jose, CABuilt 1987 · S/N 7398 N711KVAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 1070212D N711ZWMalmrose Heli Services Inc · North Salt Lake, UTBuilt 1979 · S/N 2691 N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671 N716CBCbhelos LLC · Chesapeake, VABuilt 1980 · S/N 500701D N716KVAa Leasing Lp · Lihue, HIBuilt 1990 · S/N 0407E N716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203 N7173FFour Creeks Aviation Inc · Visalia, CAS/N 2011 N7173SCraig Helicopters Inc · Craig, COBuilt 1965 · S/N 2351 N719CBCbhelos LLC · Chesapeake, VABuilt 1972 · S/N 890 N719KVAa Leasing Lp · Kilauea, HIBuilt 1979 · S/N 890579D N721KHBruce Mike · Evadale, TXFirst renewal noticeBuilt 1984 · S/N E-2214 N721RPRatcliff Dustin · Saltville, VABuilt 1981 · S/N 310918D N72269Army Aviation Heritage Foundation · Hampton, GABuilt 1971 · S/N 71-20541 N722LMNorthwest Helicopters LLC · Olympia, WABuilt 1994 · S/N 52111 N7230TFernandez Rosario Yailin · Imperial, CABuilt 2005 · S/N 72-21128 N7242NMaverick Jet Leasing Inc · Wilmington, DEBuilt 1986 · S/N 7355

Back to AD 79-21-01 R1