Registered aircraft · 3,961

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-21-02-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-21-02-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-21-02-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-21-02-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-21-02-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-21-02-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.

N821KAKa Consulting LLC · San Juan, PRBuilt 1981 · S/N 421C1203 N821TTHome By Dark LLC · Fredericksburg, TXBuilt 1976 · S/N 421C0041 N8221QSouthwest Aircraft LLC · Fairacres, NMBuilt 1971 · S/N 414-0151 N8223QBas Part Sales LLC · Greeley, COS/N 414-0153 N8229QSeppala Wayne H Trustee · El Cajon, CABuilt 1971 · S/N 414-0159 N822AMBmg Aviation Leasing LLC · Bloomington, INBuilt 1975 · S/N 310R0161 N822BKPropilot LLC · San Juan, PRS/N 421C0822 N822VWWetherbee Rodney A · Florence, ORBuilt 1978 · S/N 340A0630 N8237QAircon LLC · New Franklin, OHBuilt 1974 · S/N 340-0524 N8241QRolling Hills LLC · Plainfield, ILBuilt 1971 · S/N 4140171 N8242MGumar Sherko · Scottsdale, AZBuilt 1960 · S/N 39101 N8242QBirds Eye View Inc · Farmington, NMBuilt 1973 · S/N 310Q0715 N8243QAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 414-0173 N824BCAonvo Investment LLC · North Miami, FLBuilt 1977 · S/N 340A0306 N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411 N825GSRed River Ranch LLC · Wilmington, DEBuilt 1972 · S/N 310Q0510 N825WBeckett Jesse · Lakeway, TXS/N 340A0728 N826CMKuriel Michael · Las Vegas, NVS/N 421C0508 N829EDiaz Maria · Kansas City, MOS/N 401A0014 N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064 N82DAAircraft Holding Solutions LLC Trustee · Newark, DES/N 414A0476 N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463 N82GLJusticia Holdings LLC · Roanoke, VAS/N 414A0275 N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156 N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273 N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738 N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186 N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340 N831CPConstant Pleasure LLC · Paso Robles, CAS/N 310Q0813 N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467 N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834 N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668 N835RCDodson International Parts Inc · Rantoul, KSS/N 4040835 N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310 N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615 N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285 N83JBHuie Ag Service LLC · Beeville, TXS/N 3400061 N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835 N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350 N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443 N8422FTownsend David · Piedmont, SCS/N 402-0270 N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312 N8430NFitch John A · Cary, ILBuilt 1978 · S/N 421C0490 N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706 N845LMarshall Timothy Trustee · Tucson, AZBuilt 1982 · S/N 340A1511 N845YCFruscella Alfredo J · Tampa, FLBuilt 1973 · S/N 421B0351 N849JBDodson International Parts Inc · Rantoul, KSS/N 421A0075 N84CGGuardian Angel Homes LLC · Hayden, IDBuilt 1981 · S/N 340A1274 N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519 N84HCJeffcoat Roy B · Anderson, SCBuilt 1976 · S/N 340A0052

Back to AD 87-21-02 R1