Registered aircraft · 40,394

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.

N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590 N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701 N9616RPray Aviation Inc · Augusta, KSS/N TD-295 N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071 N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543 N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528 N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267 N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771 N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702 N9617WPoskevich Douglas P · Deland, FLS/N 28-23072 N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034 N9618DRich Beryl G · Brush Prairie, WABuilt 1958 · S/N 22-6529 N9618UN9618u LLC · Grand Haven, MIBuilt 1975 · S/N AA5-0818 N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039 N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924 N9619DSciotti Michael V · Wasilla, AKBuilt 1958 · S/N 22-6530 N9619JFlick Kristina R · Port Ewen, NYBuilt 1966 · S/N 28-3773 N9619SCulp Barney L Jr · Emerald Isle, NCBuilt 1965 · S/N 13 N9619WId Rather Knot LLC · Louisville, KYBuilt 1967 · S/N 28-23075 N961CLRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1986 · S/N 0594 N961DACondair Flyers Inc · Latham, NYBuilt 1996 · S/N 2843034 N961DJSeibly Larry · Mckinney, TXBuilt 1960 · S/N 24-1955 N961DMFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N AA5B0392 N961JJButler James C · Wharton, TXS/N 20879 N961RSJames River Pitts LLC · Yorktown, VABuilt 1978 · S/N 1001 N961SSAdams Criss E · Wasilla, AKBuilt 1996 · S/N 96-I N961TETiger Fliers LLC · Island Park, NYBuilt 2004 · S/N 10240 N961WLoma Aviation LLC · San Diego, CABuilt 1966 · S/N 28-3811 N961WGChandler Air Service Inc · Chandler, AZBuilt 2000 · S/N 2843376 N96206Registration Pending · Sioux Falls, SDRegistration pendingBuilt 1991 · S/N 1187 N9621DLimitless Outdoors · Bonners Ferry, IDBuilt 1958 · S/N 22-6532 N9621VHathor Aviation LLC · Johnstown, COBuilt 1974 · S/N 17264401 N9622CN9622c LLC · Clintondale, NYS/N 28-7816504 N9622HSanders Flight Training Center LLC · Jasper, ALBuilt 1975 · S/N 17266272 N9622JAlpha Bravo Aviation LLC · Queen Creek, AZBuilt 1966 · S/N 28-3778 N9622QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265707 N9622VVan Wyck Nicholas · Anchorage, AKFirst renewal noticeBuilt 1990 · S/N 1154 N9623JVirginia Street Partnership · Farmville, VABuilt 1966 · S/N 28-3779 N9623UBare Michael J · Paola, KSBuilt 1975 · S/N AA5-0823 N9623VSchreder Peter T · Joseph, ORS/N 17264403 N9623WLiu Kevin R · Alhambra, CABuilt 1967 · S/N 28-22988 N9623YTownsend Richard · Sagle, IDBuilt 1991 · S/N 1191 N9623ZYellowstone Aviation Inc · Jackson, WYBuilt 1991 · S/N 1188 N9624DBuster Wendy K · Forney, TXBuilt 1959 · S/N 22-6536 N9624JTideline Aviation LLC · Wilmington, NCBuilt 1966 · S/N 28-3780 N9624WJanak Jeffrey J · Corpus Christi, TXBuilt 1967 · S/N 28-23080 N9625DCentral Products Inc · Gladwin, MIBuilt 1958 · S/N 22-6537 N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709 N9625SYoung Robert A Jr · Cass, WVBuilt 1966 · S/N 57 N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405

Back to AD 79-10-03 R2