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.

N3818C18 Charlie LLC · Southern Pines, NCBuilt 1976 · S/N LW-196 N381ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-35 N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952 N38280Aerotrust Services Corp Trustee · Wilmington, DES/N LJ-953 N382ATAirtrex Registration Corp Trustee · Wichita, KSS/N FE-36 N383AAAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-13 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N383ATAirtrex Aircraft Juliet Inc · Wichita, KSS/N FE-10 N384ATAirtrex Aircraft Kilo Inc · Wichita, KSS/N FE-23 N385ATAirtrex Aircraft Lima Inc · Wichita, KSBuilt 1989 · S/N FE-22 N385EMEmerald Aviation Inc · Manassas, VABuilt 1980 · S/N LJ923 N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775 N387ASMurfin Inc · Wichita, KSS/N LJ-1417 N388AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-188 N388KFKiernan Companies LLC · Englewood, COBuilt 1981 · S/N LW-346 N389RAAirtrex Aircraft Xray Inc · Wichita, KSBuilt 1986 · S/N BL-56 N38APClear Canyon I LLC · Amarillo, TXBuilt 1988 · S/N LJ-1184 N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439 N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105 N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313 N390PMPlanemasters Ltd · West Chicago, ILBuilt 1990 · S/N UC-110 N390PSMcm Holdings Inc · Lincoln, NES/N LW-279 N390SPState Of Arkansas · Little Rock, ARS/N BB-1970 N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165 N392CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 398 N394ALTeebird Enterprises LLC · Brighton, COBuilt 1968 · S/N LJ394 N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575 N395AMHollan Air LLC · Amarillo, TXS/N BB-1101 N396FSAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N LJ-1648 N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421 N399ALBallard Aviation Inc · Newton, KSS/N BB-1623 N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203 N399WSGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1547 N39FBButler National Inc · New Century, KSS/N LJ-1165 N39UBAmeriflight LLC · Dallas, TXS/N UB-39 N3AHEat Veggies 3 LLC · Savannah, GABuilt 1987 · S/N FA-130 N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36 N3GCTexas Air & Space Museum · Amarillo, TXBuilt 1973 · S/N LJ-576 N3LSConcept Management Company LLC · Spartanburg, SCBuilt 1977 · S/N LW-245 N3MEAero F90 LLC · Oxnard, CABuilt 1980 · S/N LA-101 N3MFJ & K Aviation Inc · Conway, ARBuilt 1983 · S/N LA209 N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228 N3NCNorth Carolina Dept Transportation · Raleigh, NCBuilt 2007 · S/N BB-1976 N3PXAirtime LLC · Mont Belvieu, TXBuilt 1984 · S/N BB-1173 N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234 N400DAFive Saguaro Leasing LLC · Albuquerque, NMBuilt 1984 · S/N FA-11 N400EMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1601 N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583 N400RVMach Point Nine LLC · Phoenix, AZBuilt 1979 · S/N LJ-853 N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040

Back to AD 87-22-01 R1