Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N4854RFisher Ag Service LLC · Cardington, OHBuilt 1975 · S/N 18802373T N4855CFoss James K · Anchorage, AKBuilt 1975 · S/N 18502623 N4855VGlide Slope Aviation Inc · Myakka City, FLFirst renewal noticeBuilt 1968 · S/N 30109 N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536 N4857CGate Holdings LLC · Ketchum, IDBuilt 1979 · S/N 21063647 N4858PGreat Plains Spraying Inc · Colby, KSBuilt 1978 · S/N P21000122 N4859CHanni Walter G · Anchorage, AKBuilt 1974 · S/N 18502627 N485DSEncinal Aviation LLC · Springfield, MOBuilt 1978 · S/N 421C0459 N485HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1328 N4860WHershorin Mason P · Pembroke Pines, FLBuilt 1966 · S/N CE-119 N4863QKlamar Spraying Inc · Gatzke, MNBuilt 1976 · S/N 18802599T N4864YWilliams R E · Fort Walton Beach, FLBuilt 1980 · S/N 21064021 N4865PThundersky Farms Inc · Helena, MTBuilt 1978 · S/N P21000124 N4865VWoltjer Richard J · Pennock, MNBuilt 1968 · S/N 30110 N4866KNavion Aviation LLC · Littleton, COS/N NAV-4-1866 N4867JNational Aero Services LLC · Helena, MTBuilt 1966 · S/N TE-276 N4867KMark Thomas Productions LLC · Ketchum, IDBuilt 1979 · S/N P21000349 N4868AKlokner James B · Madison, WIBuilt 1978 · S/N 310R1393 N4868JFoster Milton F · Dawson, GABuilt 1966 · S/N TE-277 N4869CBerry Matthew G · Creedmoor, NCBuilt 1975 · S/N 18502637 N4869JDls Aviation LLC · Gilmer, TXBuilt 1966 · S/N TE-281 N486DCStephens Dana M · Coxs Creek, KYBuilt 2004 · S/N 1138 N486HPSlipstream Aviation LLC · La Crosse, WIBuilt 1989 · S/N CE-1342 N486MHMh Group LLC · Duncan, OKBuilt 1978 · S/N 340A0481 N4870CHoffman Bertha M · Bethel, AKS/N 18502638 N4871FFry Robert S Jr · Poplar Grove, ILBuilt 1966 · S/N U206-0571 N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356 N4872JAm Aviation LLC · Edmonds, WABuilt 1966 · S/N CE-127 N4872KMike Papa LLC · Newton, KSBuilt 1979 · S/N P21000351 N4874QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1978 · S/N 18503567 N4875JBeech Bound Aviation LLC · Bartlett, TNBuilt 1966 · S/N CE-124 N4875KHolland Karey Lynn · North Plains, ORBuilt 1979 · S/N P21000353 N4876VGrothe Loren L · Willmar, MNFirst renewal noticeBuilt 1968 · S/N 30118 N4876YCarson Engineering And Manufacturing Inc · Springdale, ARBuilt 1980 · S/N 21064025 N4878FNistler Gabriel R · Helena, MTBuilt 1966 · S/N U206-0578 N4878QRichter Patrick A · Edna Bay, AKBuilt 1978 · S/N 18503570 N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026 N4879FCitizen Air LLC · Port Angeles, WABuilt 1966 · S/N U206-0579 N487HPAlpha Niner Niner LLC · Winter Garden, FLBuilt 1989 · S/N CE-1333 N487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 340A0240 N4880UYanikoski Joseph A · Stoughton, MABuilt 1984 · S/N 21064831 N4880VVillage Motors Inc · Lake Village, INS/N 30122 N4881QAir Dakota Flite Inc. · Hettinger, NDBuilt 1976 · S/N 18802617T N4883FStillinger David C · Cardiff By The Sea, CABuilt 1966 · S/N U206-0583 N4886USkycase Leasing LLC · Wasilla, AKBuilt 1979 · S/N U20605144 N4887VJennings Delbert Keith · West Fargo, NDBuilt 1968 · S/N 30128 N4887ZJav Air Services LLC · Anchorage, AKBuilt 1980 · S/N U20606042 N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656 N4888FTaktos Ltd · Corvallis, ORBuilt 1966 · S/N U206-0588 N4888VBarrett James Michael · Concordia, KSBuilt 1967 · S/N 30065

Back to AD 86-13-04 R3