Registered aircraft · 1,915

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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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.

N777KNardi Greg · Titusville, FLBuilt 1982 · S/N BB-1017 N777KATake-Off LLC · Knoxville, TNBuilt 1978 · S/N LW-285 N777TQG And G Operators Ltd · Dalhart, TXBuilt 1989 · S/N BB-1335 N777XPRbwdb Aircraft LLC · Lufkin, TXBuilt 1987 · S/N FA-124 N777YNPilots Choice LLC · Shreveport, LABuilt 2001 · S/N LJ-1657 N779VFColeman Aviation LLC · Livingston, TNS/N LJ-1254 N77CESmall Plane LLC · Carson City, NVBuilt 1978 · S/N LW-257 N77HDArkansas Department Of Transportation · Little Rock, ARBuilt 1991 · S/N BB-1397 N77HEDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LJ969 N77NBDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N LJ818 N77PVSalazar Leasing LLC · Yukon, OKBuilt 1980 · S/N LA-68 N77WFKt Aviation LLC · Las Cruces, NMBuilt 1972 · S/N LW-4 N77WMWhiskey Mike Aero LLC · Wilmington, DEBuilt 1986 · S/N LJ-1133 N78Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-13 N780CWCasella Major Account Services LLC · Rutland, VTS/N BB-1924 N7817LNyerges James · Midland, TXFirst renewal noticeBuilt 1967 · S/N LD-340 N781HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2004 · S/N BB1854 N782ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1940 N783ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1946 N785JPGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1710 N786DDTransouth Leasing LLC · Longview, TXS/N BB-1171 N786ZAZulu Air LLC · Opa Locka, FLBuilt 1994 · S/N LJ1388 N787TTMjw Aviation LLC · Beaumont, TXS/N LJ-787 N78BABuckley Aviation LLC · Swainsboro, GABuilt 1998 · S/N LJ1529 N78CTCt Air LLC · Middletown, DES/N LJ-1705 N78DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-78 N78DARegistered aircraftBuilt 1976 · S/N BE-11 N78QRQrp Air LLC · Quincy, ILBuilt 2004 · S/N LJ-1699 N78SVBba Aviation LLC · Raleigh, NCBuilt 1997 · S/N LJ-1504 N79Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-14 N790AWilliam C New Aviation Services LLC · Morgan City, LABuilt 1982 · S/N LJ-1016 N791DCExecutive Air Taxi Corporation · Bismarck, NDBuilt 1991 · S/N BB-1402 N7931DJet Air Inc · Galesburg, ILBuilt 1982 · S/N LJ-1049 N793DCBillings Clinic · Billings, MTBuilt 1991 · S/N BB-1404 N797CFAmerican Aviation Inc · Brooksville, FLBuilt 1978 · S/N LJ-797 N797KDDodson International Parts Inc · Rantoul, KSS/N BL68 N799ALDelt Holdings Orange LLC · Dubuque, IABuilt 1988 · S/N FA-157 N799GKCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-799 N799MCPerry King Air LLC · Perry, GABuilt 1982 · S/N BB-998 N79EFPonca International LLC · Ponca, ARS/N BB1350 N79TEPollard Aircrfaft Sales Inc · Fort Worth, TXBuilt 1985 · S/N FA-67 N79WDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-77 N7NANasa Armstrong Flight Research Center · Edwards, CABuilt 1982 · S/N BB-997 N7PCMoorhead Equipment LLC · Belton, SCBuilt 1966 · S/N LC-246 N7RLRbr Development LLC · West Plains, MOS/N LJ-1161 N80Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-15 N800BSM&F Western Products Inc · Sulphur Springs, TXBuilt 1998 · S/N BB-1620 N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24 N800PGHelio Aircraft Inc · Fort Lauderdale, FLBuilt 1991 · S/N LJ-1286 N800PKFarmers Oil Co Inc · Anthony, KSBuilt 1981 · S/N BB-982

Back to AD 87-22-01 R1